what is sql optimization



what is sql optimization..

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.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

What are different joins used in sql?

0 Answers  


query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,


What is sql constant?

0 Answers  


How do you define a foreign key?

0 Answers  


What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,






Do we need to create index on primary key?

0 Answers  


Can we insert delete data in view?

0 Answers  


Can we group by two columns in sql?

0 Answers  


how to escape special characters in sql statements? : Sql dba

0 Answers  


What is difference between hql and sql?

0 Answers  


What are two virtual tables available during database trigger execution ?

2 Answers  


How can use stored procedures in sql?

0 Answers  


Categories