Oracle 9i hidden feature: Virtual Index.
Q) What is virtual index:
a) It is hidden index because not showing up or display in data dictionary views.
Q) Does it occupy space from disk?
a) No it not occupy disk space.
Q) What is usage of virtual index?
a) For checking up to tune sql in explain plan.
Q) Why it is hidden?
a) Because it is deployment feature of OEM not from SQL*Plus
For more detail kindly check following link:
Thanks and regards,
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.