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
- 11373 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
Explain about thread and memory management process of SQL?
Can sql servers linked to other servers like oracle?
What is database dimension? : sql server analysis services, ssas
What is data source document?
What is subreport?
How do you delete duplicate records in sql server?
How does Report Builder support Analysis Services cubes?
Why I am getting this error when renaming a database in ms sql server?
How many types of schemas are there?
How to transfer data from a cursor to variables with a "fetch" statement?
What is normalization and what are the advantages of it?
How to test values returned by a subquery with the in operator?
How can you list all the table constraints in a database?
Explain rdbms?
How would you choose between a clustered and a non-clustered index?
