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.

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  

---

What is pessimistic concurrency control? : Transact sql

0 Answers  

---

How do you sort in sql?

0 Answers  

---

What does select top 1 do in sql?

0 Answers  

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

Is postgresql a nosql database?

0 Answers  

---

How do you retrieve the second highest salary from a table?

3 Answers  

---

What is difference between my sql and sql?

0 Answers  

---

What view means?

0 Answers  

---

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

---