1.

Tell Me In Brief The Cursor Optimization Tips?

Answer»

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

The following are few tips for cursor optimization:


Discussion

No Comment Found

Related InterviewSolutions