Answer / Ahmad Ashraf

Types of optimization in SQL include query optimization, database design optimization, physical database optimization, and application-level optimization. Each type focuses on a different aspect to improve overall performance.

tell us something about heap tables. : Sql dba

1 Answers  

---

How do I copy a table in sql?

1 Answers  

---

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

---

What is sql indexing?

1 Answers  

---

What does where 1/2 mean in sql?

1 Answers  

---

What is a .db file?

1 Answers  

---

what is commit? : Sql dba

1 Answers  

---

Can we use rowid as primary key?

1 Answers  

---

What is an exception in pl/sql?

1 Answers  

---

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

---

What is the use of sql trace?

1 Answers  

---

What is the difference between numeric and autonumber?

1 Answers  

---