RE: Shadow Indexes

Will this change an explain plan as well? I'd test it but don't have access
to oracle right now. 
 
  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Bobak, Mark
Sent: Thursday, September 28, 2006 5:22 PM
To: jkstill@xxxxxxxxx; Oracle-L Freelists
Subject: RE: Shadow Indexes
 
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

Other related posts: