Re: reasons to separate indexes and data in different tablespaces
From: Nilo Segura <nilosegura_at_gmail.com>
Date: Fri, 16 May 2008 00:19:27 +0200
Message-ID: <4ce989e0805151519q19e1837ax70ff95123092edd1@mail.gmail.com>
Date: Fri, 16 May 2008 00:19:27 +0200
Message-ID: <4ce989e0805151519q19e1837ax70ff95123092edd1@mail.gmail.com>
Very good reading on this subject can be found on Richard Foote's blog..
http://richardfoote.wordpress.com/2008/04/16/separate-indexes-from-tables-some-thoughts-part-i-everything-in-its-right-place/ http://richardfoote.wordpress.com/2008/04/18/separate-indexes-from-tables-some-thoughts-part-ii-there-there/ http://richardfoote.wordpress.com/2008/04/23/separate-indexes-from-tables-some-thoughts-part-15-think-for-yourself/ http://richardfoote.wordpress.com/2008/04/28/indexes-in-their-own-tablespace-availabilty-advantages-is-there-anybody-out-there/ http://richardfoote.wordpress.com/2008/05/02/indexes-in-their-own-tablespace-recoverability-advantages-get-back/
It covers pretty much everything you need to know about this index/data tablespace(s) story..
ciao.
--
Nilo Segura
Oracle Support - IT/DES
CERN - Geneva
Switzerland
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 15 2008 - 17:19:27 CDT