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
- 4672 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 are file groups?
What are the types of containers in ssis?
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz
What are the different types of collation sensitivity?
how to get max salary with employee number by using one select query and max function ??
How do I find query history in sql server?
Explain candidate key, alternate key, and composite key?
What is difference between equi join and natural join?
What are magic tables in sql server?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Where can you find the error log information? : sql server database administration
can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?
-
Oracle (3253) - 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)
