Creating an Invisible Index

An invisible index is an index that is ignored by the optimizer unless you explicitly set the OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter to TRUE at the session or system level.
To create an invisible index: 
  • Use the CREATE INDEX statement with the INVISIBLE keyword.
    The following statement creates an invisible index named emp_ename for the ename column of the emp table:

CREATE INDEX emp_ename ON emp(ename)
      TABLESPACE users
      NEXT 20k)

  • July 26, 2016 | 15 views
  • Comments