Re: Dynamically recreating indexes on materialized views

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Fri, 10 Mar 2006 15:22:50 +1100
Message-ID: <MPG.1e7a52094e137191989781@news.readfreenews.net>

j.w.vandijk.removethis_at_hetnet.nl says...

> <geoff.muldoon_at_trap.gmail.com> wrote:

> >
> >Is this the recommended way to go, or am I way off track?
> >

> - perform an 'alter session set skip_unusable_indexes = true'

<slaps back of head with clue-stick>
How did I fail to think of the elegantly easy solution and instead hit a thumbtack with a sledgehammer?

IOU one large virtual beer. Thanks.

GM Received on Thu Mar 09 2006 - 22:22:50 CST