Answer Posted / 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 View All Answers
Is it possible to link two groups inside a cross products after the cross products group has been created?
Explain how to use transactions efficiently : transact sql
What are the sql versions?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
How do you update a value in sql?
how to do backup entire database? : Transact sql
how to load data files into tables with 'mysqlimport'? : Sql dba
what are the difference between clustered and a non-clustered index? : Sql dba
how to enter binary numbers in sql statements? : Sql dba
What are the uses of sysdate and user keywords?
What is a table?
Describe types of sql statements?
Why we use joins in sql?
Is sql pronounced sequel or sql?
What will you get by the cursor attribute sql%notfound?
