Re: BAARF

Havent' you heard about the theory of relativity?

1 - ideal - full recovery with indexes
2 - relatively less than ideal - having to rebuild indexes

It doesn't mean you should aim for 2, but you sure want to keep 2 as an option. If you don't have separate index tablespaces, you are simply limiting your options. In a recovery situation you want all the options you can get!

> Indexes are largely built for one of two reasons
>
> A) to make performance acceptable.
> B) to enforce constraints.
>
> In a media recovery situation, recovering but with unacceptable
> performance or locking issues probably doesn't really constitute
> recovery. Now If it can be shown that trashing the index tablespace and
> rebuilding is generally faster than restoring datafiles and applying
> logs I might be more convinced but at the moment I'm not so sure. So is
> this garbage Or not.?
>
> Niall

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Binley Lim
  INET: Binley.Lim_at_xtra.co.nz

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).