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 aggregate function in sql?

0 Answers  

---

What is mutating table error?

0 Answers  

---

what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  

---

How do I truncate a sql log file?

0 Answers  

---

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

---

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

---

Why do we go for stored procedures?

0 Answers  

---

Can we delete column in sql?

0 Answers  

---

What is data abstraction in sql?

0 Answers  

---

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

---

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

---

How do I send sql query results to excel?

0 Answers  

---