Oracle DB Optimization Question:
Download Job Interview Questions and Answers 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.
Download Oracle Database Optimization Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain Execution Plan? | Do you have any idea what are indexes? |