Tag Archives: Virtual Index in Oracle

How to use Virtual Index in Oracle

Last updated on September 21st, 2017 at 05:23 pmWhat is ┬áVirtual Index in Oracle ? a) A virtual index is a “fake” index whose definition exists in the data dictionary, but has no associated index segment. b) Many time tuning advisor recommends you creating new index and you want to test the new index. In this case It can take good amount of time to … Continue reading How to use Virtual Index in Oracle »