What are the steps you will take to improve performance of a
poor performing query?
Answer Posted / m.sivakumar
Some general issues that you could talk about would be:
No indexes,
table scans,
missing or out of date statistics,
blocking, excess recompilations of stored procedures,
procedures and triggers without SET NOCOUNT ON,
poorly written query with unnecessarily complicated joins,
too much normalization, excess usage of cursors and temporary
tables.
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is executereader?
How to download and install microsoft sql server management studio express?
If we delete pack Spec what will be the status of pack Body ?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What are the difference between clustered and a non-clustered index?
How to create a testing table with test data in ms sql server?
What is multilevel indexing?
What is the process of normalising?
Can you explain different types of joins?
How do I make a resultset scrollable?
Do you know what is sql service broker?
What are the different type of replication in sql server?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
List the ways in which dynamic sql can be executed?
What is instead of dml trigger?