Tell me in brief the cursor optimization tips?
Submitted by: AdministratorThe following are few tips for cursor optimization:
- When the cursor is not needed, close the cursor
- Deallocate the cursor after closing it.
- Fetch less number of rows.
- Avoid triggers – because trigger executes whenever data gets updated, leads to overload of the system.
- When the rows are not need to update, use the option FORWARD ONLY
- Use where instead of having clause unless it is essential
Submitted by: Administrator
- When the cursor is not needed, close the cursor
- Deallocate the cursor after closing it.
- Fetch less number of rows.
- Avoid triggers – because trigger executes whenever data gets updated, leads to overload of the system.
- When the rows are not need to update, use the option FORWARD ONLY
- Use where instead of having clause unless it is essential
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. |