Re: Oracle 11g - Invisible Indexes

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 13 Aug 2007 10:17:09 -0700
Message-ID: <bf46380708131017i27e1e4br451c4e8ee5c1ba8f@mail.gmail.com>

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

Received on Mon Aug 13 2007 - 12:17:09 CDT