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
- 4676 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 |
Do you know what is sql injection?
How to Update from select query in sql server?
What are the differences between triggers and stored procedures?
what is the signification difference of this bit data type between sql 6.5 and later version sql server?
What are the diifferences between the ms sql server vs mysql?
How to sort the query output with order by clauses in ms sql server?
What is the difference between TRUNCATE and DROP?
What is difference between temp table and cte?
How to Get the last identity value used
how to count datewise data in sqlserver
4 Answers CarrizalSoft Technologies, IndusInd Bank,
What is an entity-relationship diagram (erd)?
What Is The Difference Between Primary Key & Super Key
-
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)
