Friday, September 24, 2021
dbametrix
More
    HomeOracle InternalsOracle 9i hidden feature

    Oracle 9i hidden feature

    Hi,

    Oracle 9i hidden feature: Virtual Index.

    - Advertisement -
    dbametrix

    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.

    - Advertisement -
    dbametrix

    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:

    http://dbametrix.com/download_info.php

    Thanks and regards,
    Gitesh Trivedi
    http://www.dbametrix.com

    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    Recent Comments