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


Please Help Members By Posting Answers For Below Questions

What are .mdf files?

503


Can group functions be used in the order by clause in ms sql server?

565


How to change server name in sql server?

534


Explain important index characteristics?

540


Explain the different index configurations a table can have?

486






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?

2092


What is an execution plan?

547


What is data file in computer?

516


How many levels of sp nesting is possible?

562


What is auditing in sql server?

480


What is cached report?

102


Comment,Datatypes are unlimited

1602


What is the security model used in sql server 2005?

491


Explain about SQL server 2005?

538


How to create sub reports?

190