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