Tell me in brief the cursor optimization tips?

Submitted by: Administrator
The 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

Read Online Oracle DB Optimization Job Interview Questions And Answers