Re: separate tablespaces for tables and indexes

Jeffery,
 That brings up the age old contriversy if seperating ifo on different
spindles.
there are many reasons one might like to separate data and indexes,
ease of backing up your data by type on different tapes,
the ability of a database to function incase of an index disk failure,
OFA,
Ease in managing disk growth

ON the other hand..
If the data and index are on one disk the supposidly the info retrievel
is faster
because the disk head is already in motion,
It takes less disks if the data and index are combined.
Etc.
The answer is "it all depends..."
Ron


>>> "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx> 12/13/2004 2:05:20 PM
>>>
We have started using locally managed tablespaces for all new
tablespaces.  We create the tablespaces with autoallocate.  
 
Since the tablespaces are locally managed, is there a need to separate
the tables and indexes anymore?
 
 
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

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

Other related posts: