Re: Oracle 11g - Invisible Indexes
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: robertgfreeman@xxxxxxxxx
- Date: Mon, 13 Aug 2007 10:17:09 -0700
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:
