Tell me some reasons of poor performance of query?
Submitted by: AdministratorNo 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Oracle DB Optimization Job Interview Questions And Answers
Top Oracle DB Optimization Questions
| ☺ | Do you have any idea what are indexes? |
| ☺ | Tell me what is Index tuning? |
| ☺ | Do you know what are the ways to code efficient transactions? |
| ☺ | Tell me what are the types of Indexes? |
| ☺ | Explain some disadvantages of the Indexes? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
