RE: Shadow Indexes

From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
To: <jkstill@xxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 28 Sep 2006 18:21:32 -0400

The magic phrase is 'NOSEGMENT'.
 
But, if you're on 9.2.0.x and x < 8, don't create a bitmap nosegment
index, or you won't be able to drop it. ;-)
 
(Just hit that bug, and applied the 9.2.0.8 patch yesterday to fix the
problem.)
 
-Mark
 

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

For a successful technology, reality must take precedence over public
relations, for Nature cannot be fooled.  --Richard P. Feynman, 1918-1988

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Thursday, September 28, 2006 6:20 PM
To: Oracle-L Freelists
Subject: Shadow Indexes



Does someone here recall the syntax for creating metadata only indexes?

This for use by the SQL tuning advisors, etc.

I can't recall the syntax, and cannot find it.

Thanks,

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

Follow-Ups:

RE: Shadow Indexes
From: Ken Naim

References:
- Shadow Indexes
  - From: Jared Still

RE: Shadow Indexes

Other related posts: