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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark
Sent: Thursday, September 28, 2006 5:22 PM To: jkstill_at_gmail.com; 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 28 2006 - 18:36:26 CDT