How to use Virtual Index in Oracle Database

What is  Virtual Index in Oracle ? A virtual index is a “fake” index whose definition exists in the data dictionary, but has no associated index segment. Many time sql 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 …

How to use Virtual Index in Oracle Database Read More »