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 is recursive stored procedure? : Sql dba

0 Answers  

---

Fetch an entire row from the employees table for a specific employee ID:

2 Answers  

---

what are the differences between char and nchar? : Sql dba

0 Answers  

---

How to disable a trigger name update_salary?

0 Answers  

---

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

---

---

What does desc stand for?

0 Answers  

---

What is the command used to fetch the first 5 characters of a string?

0 Answers  

---

What is sql*plus?

0 Answers  

---

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---

What is dynamic query?

0 Answers  

---

What is Difference Between delete and Truncate?

9 Answers  

---

Why select is used in sql?

0 Answers  

---