RE: Oracle 11g - Invisible Indexes
- From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 19 Aug 2007 23:06:16 -0600
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:
