What are the factors you will check for the performane
optimization for a database query?
Answer Posted / pushpendra kumar
The important factors for performance optimization are as
follows:
1. Proper data type assignment;
2. Selection of proper data reader;
3. Proper command to retrieve the data from the database.
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
what is a live lock? : Sql server database administration
How is SQL Azure different than SQL server?
What are the ways available in sql server to execute sql statements?
How to write a query with an inner join in ms sql server?
What are the kinds of subquery?
What are the different types of backups avaialabe in sql server 2005?
How optimize sql query with multiple joins in sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Explain what is “asynchronous” communication in sql server service broker?
Explain indexed views?
What is the security principal at the database level that represents your session?
What is a covering index?
Which is the main third-party tool used in sql server?
what is the primary use of the model database? : Sql server administration
Define full outer join?