Oracle DB Optimization Question: Download Oracle Database Optimization PDF
Tell me some reasons of poor performance of query?
Answer:
No indexes
Excess recompilations of stored procedures.
Procedures and triggers without SET NOCOUNT ON.
Poorly written query with unnecessarily complicated joins
Highly normalized database design.
Excess usage of cursors and temporary tables.
Excess recompilations of stored procedures.
Procedures and triggers without SET NOCOUNT ON.
Poorly written query with unnecessarily complicated joins
Highly normalized database design.
Excess usage of cursors and temporary tables.
| Previous Question | Next Question |
| Explain Execution Plan? | Do you have any idea what are indexes? |