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
How to select 10 records from a table?
What is the mutating table and constraining table?
How do I create a memory optimized filegroup?
How do I partition a table in sql?
Why triggers are used?
What is the difference between the conventional and direct path loads? : aql loader
explain access control lists. : Sql dba
What is crud sql?
What is a boolean in sql?
what is rollback? : Sql dba
What are the different ddl commands 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
Why select is used in sql?
How does sql*loader handles newline characters in a record? : aql loader
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
