RE: Oracle 11g - Invisible Indexes

This was apparently removed from production. I tested it in production, and hints no longer work. They DID work in Beta.

RF

Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com! BLOG: http://robertgfreeman.blogspot.com/ Sig V1.2

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared Still   Sent: Monday, August 13, 2007 11:17 AM   To: robertgfreeman_at_yahoo.com
  Cc: oracle-l_at_freelists.org
  Subject: Re: Oracle 11g - Invisible Indexes

  On 8/12/07, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:     On my blog now, 11g New Feature, Invisible Indexes.

    http://robertgfreeman.blogspot.com/

    Enjoy!!

  Robert,

  In your blog you mention that the production docs no longer mention   making an invisible hint usable via hints.

  From the 'New Features Guide':

  1.2.9.4 Invisible Indexes
  An invisible index is an alternative to making an index unusable or even to drop it. An
  invisible index is maintained for any DML operation but is not used by the optimizer
  unless you explicitly specify the index with a hint.

  These docs were downloaded last week.

  Have they changed since then?

  --
  Jared Still
  Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l