Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors you will check for the performane
optimization for a database query?
- 7 Answers
- 11679 Views
- CarrizalSoft Technologies, DELL, SoftSol, I also Faced
- E-Mail Answers
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
How to sort the query output with order by clauses in ms sql server?
Create and insert into temp table in sql server?
Explain the etl (extraction, transformation, and loading)?
How to assign null values to variables or columns?
What is usually the first word in a sql query?
What are data files?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
Explain the usage of floor function in sql server.
Explain filtered indexes?
What are dml triggers and types of dml triggers?
What is a dbms wizard?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
How to write a query with an inner join in ms sql server?
Explain filestream storage of sql server 2008?
What is the filtered index?
