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
What is the difference between sum and count in sql?
What is foreign key and example?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What are different sql data types?
What is the difference between sql, mysql and sql server?
Explain how can you save or place your msg in a table?
What is the difference between jpql and sql?
What is pl sql and why it is used for?
how to calculate the difference between two dates? : Sql dba
How many unique keys can a table have?
what is the command line end user interface - mysql? : Sql dba
What does a pl/sql package consist of?
What is normalisation in sql?
How to run pl/sql statements in sql*plus?
Name the operator which is used in the query for pattern matching?
