Oracle 11g hints update…

 

From Oracle 11g version we have following new hints which are introduced in support for edition based redefinition.

CHANGE_DUPKEY_ERROR_INDEX,  IGNORE_ROW_ON_DUPKEY_INDEX and
RETRY_ON_ROW_CHANGE.

I have provided the demo for the above hints and how basically hint works. Perhaps, when we compare across the Performance of usually programming for checking duplicate records prior to insert with hints, it would not provide much performance gain.

http://sites.google.com/site/oraclepracticals/oracle-sql

The above two hints are in support with  “Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.”

further refer to Oracle documentation.