Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps you will take to improve performance of a
poor performing query?
- 1 Answers
- 4615 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
Explain comment on transactions?
What is Federation Root Database?
What stored by the master?
How to drop an existing table?
Can an automatic recovery be initiated by a user?
Do you know what is sql injection?
What is not null constraint?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
How many full-text indexes can a table have?
If no size is defined while creating the database, what size will the database have?
If the job running very slow what is the action you do
What is 4nf in normalization form?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the difference between Normalization and De-normalization?
What is instead of dml trigger?
