What are the factors you will check for the performane
optimization for a database query?
Answer Posted / murtaza
first we will check the columns which r there in table.
then the frequency of usage of each columns.Index should be
created on those columns which has maximum usage or columns
which can be use frequently.
so to check which columns should have the index and how we
can optimize the query can be done by
1.SQL Profiler
2.By Normalization
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain where clause?
How to make a column nullable?
Difference between Sql server reporting services and Crystal reports?
How to Sync Two SQL Azure Databases?
Why would you call update statistics?
Explain aggregate functions?
Can an automatic recovery be initiated by a user?
Can another user execute your local temporary stored procedures?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is an identity column in insert statements?
Please explain what is “asynchronous” communication in sql server service broker?
Do you know sql server 2008 introduces automatic auditing?
What are the kinds of subquery?
What is collation sensitivity? Explain different types.