Interested to Buy Any Domain ? << Click Here >> for more details...
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 primary key secondary key alternate key candidate key?
What is the difference between inner join and left join?
What is the difference between delete and truncate statement in sql?
What is the sql*loader? : aql loader
What is package in pl sql?
What is a sql*loader control file?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What are the types of keys?
Why having clause is used in sql?
What is an ndf file?
What is the plv (pl/vision) package offers?
What is the life of an sql statement?
What is a scalar value in sql?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
what is bcp? When is it used?
