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
What are .mdf files?
Can group functions be used in the order by clause in ms sql server?
How to change server name in sql server?
Explain important index characteristics?
Explain the different index configurations a table can have?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is an execution plan?
What is data file in computer?
How many levels of sp nesting is possible?
What is auditing in sql server?
What is cached report?
Comment,Datatypes are unlimited
What is the security model used in sql server 2005?
Explain about SQL server 2005?
How to create sub reports?