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 key differences between SQL and PL SQL?

0 Answers  

---

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

---

Explain how can you save or place your msg in a table?

0 Answers  

---

How to return more than one value from a function?

11 Answers   Satyam,

---

Where the Pre_defined_exceptions are stored ?

2 Answers  

---

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 Answers  

---

What is nvl?

0 Answers  

---

How delete a row in sql?

0 Answers  

---

What is a data definition language?

0 Answers  

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

How packaged procedures and functions are called from the following?

2 Answers  

---

What does the file extension accdb stand for?

0 Answers  

---