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
- 4499 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
what is the difference between group and having give an example with query and sample output
What is the use of MOVE keyword in restore command
About DTS usage ?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is blocking and how would you troubleshoot it?
How to create an multi-statement table-valued function?
What is the difference between for xml raw and for xml auto?
Where is trigger in sql server?
where the connection string store in the database
Working with TLogs
How does normalization work?
What do you know about normalization and de- normalization?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
