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 loop in pl sql?
Define union, minus, union all, intersect ?
State few characteristics of pl/sql?
What is a trigger word?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is the use of prepared statement?
What are properties of the transaction?
How do I truncate a word?
What are the two types of periodical indexes?
What is left join in postgresql?
How do I use google cloud in sql?
How to select random rows from a table?
What is a clob in sql?
Is record in oracle pl sql?
What is dcl in sql?
