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
- 11636 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
What are null values in ms sql server?
Explain left outer join and right outer join?
Describe and explain about SQL native client?
Why use identity in sql server?
Can a rule be bound to any column of any data type?
Why functions are used in sql server?
what is the main function of a query parameter?
What is 5nf in normalization form?
How to create hyperlink from returned sql query ?
What are pages and extents? : SQL Server Architecture
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Explain raiserror in sql server?
What is the difference between a check constraint and a rule?
What are the methods used to protect against sql injection attack?
What is sql service broker?
