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 in place upgrade in sql server?
Explain trigger and its types?
What do you mean by a dependent functionality in a build?
How can we remove orphan records from a table?
How to run sql server 2005 books online on your local system?
How to create an inline table-valued function?
Explain error and transaction handling in sql server?
What is “asynchronous” communication in sql server service broker?
What is the current pricing model of SQL Azure?
what happens on checkpoint? : Sql server database administration
what are acid properties? : Sql server database administration
What is a periodical index?
What are the reporting services components?
How do I create an extended event in sql server?
What is indexed view?