Virtual Index Virtual indexes allow us to simulate the existence of an index and test its impact without actually building the actual index. Only sessions marked for Virtual Index usage will be affected by their existence. Their creation does not affect new sessions. Virtual indexes will be used only when the initialization parameter “_use_nosegment_indexes” is […]
Articles Tagged: Virtual Index
Virtual Index or Fake Index in Oracle
Oracle has come up with a feature called virtual index in oracle 9i. This feature allow us to test an index on a table without actually adding an index on the table. The table will be visible only in our session and will be used by our queries only (if optimizer decide it to use). […]