What is an invisible index?

August 10th, 2009 by uCertify Leave a reply »

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.
  • Share/Bookmark
Advertisement

Leave a Reply

uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.