Re: separate tablespaces for tables and indexes

  • From: David Sharples <davidsharples@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>, thomas.mercadante@xxxxxxxxxxxxxxxxx
  • Date: Mon, 13 Dec 2004 19:30:46 +0000

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

for a good explanation

On Mon, 13 Dec 2004 14:19:56 -0500, Mercadante, Thomas F
<thomas.mercadante@xxxxxxxxxxxxxxxxx> wrote:
> David,
> Please describe your definition of "never".  :)

> -----Original Message-----
> From: David Sharples [mailto:davidsharples@xxxxxxxxx]
> Sent: Monday, December 13, 2004 2:08 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: separate tablespaces for tables and indexes
> never was any need

Other related posts: