Virtual Indexes are another undocumented feature used
by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will
not behave the same way that normal indexes behave, and are meant for a very
A virtual index is created in a slightly different manner
than the normal indexes. A virtual index has no segment pegged to it, i.e., the
DBA_SEGMENTS view will not show an entry for this. Oracle handles such...