Re: Oracle 11g - Invisible Indexes

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 20 Aug 2007 17:28:30 -0700
Message-ID: <bf46380708201728q7fc7fee7g5ff4c114e5db1d62@mail.gmail.com>

On 8/20/07, Greg Rahn <greg_at_structureddata.org> wrote:
>
>
> If you are a DBA and want to try to test an index in production, this
> is a prefect way to do so - it limits the risk exposure.
>

Good point.

Previously is was possible to only go partway with this via NO SEGMENT indexes,
which affected only the execution plan, but could not be used for an actual query.

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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 20 2007 - 19:28:30 CDT