Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Skip a particular Index

754320Feb 17 2010 — edited Feb 17 2010

A quick one about Oracle Indexes....

Is it possible to disable a particular index (for a period of time) but still keep it online such that all changes are still updated in the index but it is not used during queries? I don't want to rebuild the index when I enable it again.

This post has been answered by Uwehesse-Oracle on Feb 17 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 17 2010

Added on Feb 17 2010

#11g, #general-database-discussions, #index

10 comments

1,597 views