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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jared Still
  Sent: Monday, August 13, 2007 11:17 AM
  To: robertgfreeman@xxxxxxxxx
  Cc: oracle-l@xxxxxxxxxxxxx
  Subject: Re: Oracle 11g - Invisible Indexes


  On 8/12/07, Robert Freeman <robertgfreeman@xxxxxxxxx> 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

Other related posts: