Answer / anupam bhatt

SQL optimization or tuning is the process to improve upon your sql queries to make them more efficient and avoid common pitfalls like multiple database round trips etc. Basically do more work with fewer queries to make the application fast and manageable.

This can be achieved by various ways like joining multiple queries in to one to avoid multiple network round trips, add indexes to the tables which are frequently accessed to reduce the turnaround time, fetch only the required data instead of a generic query getting all of the data of the table etc.

What are sql commands?

0 Answers  

---

25.67,-1 Trunc = 20 Round= 30 HOW????

2 Answers   Karrox,

---

Mention what are different methods to trace the pl/sql code?

0 Answers  

---

How many primary keys can a table have?

0 Answers  

---

Can we create foreign key without primary key?

0 Answers  

---

How do we use distinct statement? What is its use?

0 Answers  

---

what is sql profiler

2 Answers   Fidelity,

---

What is the mutating table and constraining table?

0 Answers  

---

What does pl sql stand for?

0 Answers  

---

what is the different between now() and current_date()? : Sql dba

0 Answers  

---

How to display the contents of a current record fetched in a reference cursor?

2 Answers  

---

List the different type of joins?

0 Answers  

---