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.

Why do we create views in sql?

0 Answers  

---

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---

Is subquery faster than join?

0 Answers  

---

What is the usage of when clause in trigger?

0 Answers  

---

What are different sql data types?

0 Answers  

---

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

What does inner join mean?

0 Answers  

---

What is the use of nvl function?

0 Answers  

---

What are the pre requisites?

1 Answers  

---

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

---

What are the operators in sql?

0 Answers  

---

How many columns should be in an index?

0 Answers  

---