Re: separate tablespaces for tables and indexes

well a table and its index were never accessed at the same time anyway - always serially., always one then the other - so it doesnt matter if they were in the same tabespace / disk anyway.

Back in the old todays, before SAN's and striping and all that placing hot segments on different disks was a good idea, but a process using a table and its index would never benefit from it

So doing it for performance was / is a 'myth'. For management sure splitting them could be a good idea

see http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:901906930328 for a good explanation

Dave
On Mon, 13 Dec 2004 14:19:56 -0500, Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us> wrote:
> David,
>
> Please describe your definition of "never". :)
>

> -----Original Message-----
> From: David Sharples [mailto:davidsharples_at_gmail.com]
> Sent: Monday, December 13, 2004 2:08 PM
> To: oracle-l_at_freelists.org
> Subject: Re: separate tablespaces for tables and indexes
>
> never was any need

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