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.

Write the command to remove all players named sachin from the players table.

0 Answers  

---

Can you select everything, but 1 or 2 fields, without writer's cramp?

0 Answers  

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

---

How does postgresql compare to "nosql"?

0 Answers  

---

How do sql databases work?

0 Answers  

---

---

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

---

How do you drop a trigger?

0 Answers  

---

Is sql better than excel?

0 Answers  

---

what is sql? : Sql dba

0 Answers  

---

How to get help at the sql prompt?

0 Answers  

---

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

---

What is the default value of CHAR type?

3 Answers   Bosch,

---