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 are the advantages of pl sql?

0 Answers  

---

How do I enable sql encryption?

0 Answers  

---

Is left join inner or outer?

0 Answers  

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

How to find string or key value using pl/sql code?

2 Answers   Ramco,

---

---

What is a column in a table?

0 Answers  

---

how to findout the 100th maximum salary

28 Answers   Amdocs,

---

What is a sql statement?

0 Answers  

---

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

---

difference between oracle 8i and oracle 9i

8 Answers  

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers  

---

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

---