What are the steps you will take to improve performance of a
poor performing query?
- 1 Answers
- 4232 Views
- I also Faced
- E-Mail Answers
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
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What is statement level trigger?
How will you find out if there are expensive SQL statements running or not?
How to truncate the log in sql server 2012? : sql server database administration
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Explain primary key in sql server?
What is bit data type? What's the information that can be stored inside a bit column?
what types of replication are supported in sql server? : Sql server database administration
Can you explain powershell included in sql server 2008?
What is use of @@ spid in sql server?
Tell me what is log shipping?
what's the difference between a primary key and a unique key? : Sql server database administration
Is it possible to create trigger on views?
what authentication modes does sql server support? : Sql server database administration
What are a database and a data warehouse?
