What are the steps you will take to improve performance of a
poor performing query?
- 1 Answers
- 3970 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 |
How to perform backup for certificates in sql server? : sql server security
What is entity data services?
Explain couple pf features of SQL server
How to start and end transact-sql statements?
What are the different types of normalization?
what is database replication? : Sql server database administration
What is an expression in ms sql server?
Explain primary key, foreign key and unique key?
What stored procedure can you use to display the current processes?
explain different types of constraints? : Sql server database administration
How to get @@error and @@rowcount at the same time?
What is primary key and example?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
