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
Why is sql important?
What is a recursive stored procedure?
What happens when a trigger is associated to a view?
What is trigger point?
Which one is faster ienumerable or iqueryable?
What is secondary key?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How can we store rows in PL/SQL using array?
What are the set operators in sql?
what is a database? : Sql dba
What are the different sql commands?
How many row comparison operators are used while working with a subquery?
What is trigger explain with example?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
How do you use join?
