Oracle Logbook

August 19, 2009

Virtual Index

Filed under: Uncategorized — heliodias @ 4:33 pm

The importance of virtual index on database is allow us try what will happen if we decide create the index.
The syntax is quite simple, just add “nosegment” on the end of the create index command.
You must also remember to temporary alter the hidden parameter “_use_nosegment_indexes” to true .
Then check if the execution plan change as you planned and back the _use_nosegment_indexes to false

Advertisements

Blog at WordPress.com.