Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Separating Tables and Indexes
artmt_at_hotmail.com wrote:
> With a RAID5 disk system is there any advantage to separating tables
> and indexes into separate tablespaces?
>
> Thanks
> Art
>
Only from a management perspective, not from a performance perspective. If it is easier to manage the database with your tables and indexes stored in separate tablespaces, then go ahead and do it. Personally, I do not separate my indexes from my tables, as a general rule of thumb...
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Mon Jul 31 2006 - 12:48:18 CDT