What are the steps you will take to improve performance of a
poor performing query?
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 |
Find first and last day of current month in sql server
What is de-normalization and when do you do it?
How to use linked server?
Does the unique constraint create an index?
Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance
What is a collation?
Explain fundamentals of Data ware housing & OLAP?
Which joins are sql server default?
List down some advantages of sql stored procedure?
What are different replication agents and what's their purpose? : sql server replication
What happens if you delete a table that is used by a view?
What is Online Index Rebuild Operation?
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)