An invisible index is a new feature introduced in Oracle 11g. It is used to make an index invisible. An index can be made invisible while creating it or by using the ALTER INDEX command. An invisible index is ignored by SQL optimizer when computing the plan for a SQL.
Download free practice test for 1Z0-050 OCP 11g: New Features for Administrators exam.
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.