Re: Data and Indexes in separate tablespaces

Charlie3101_at_hotmail.com (Charlie Edwards) wrote in message news:<db479d88.0206270803.75291cb0_at_posting.google.com>...
> No, I'm not trying to start THAT thread again.
>
> Apologies for this, but does anybody know the location of a white
> paper or document that outlines the fact that there are no performance
> benefits to splitting data and indexes into separate tablespaces
> (disks)?
>
> I have looked round (I promise, I really have) but I can't find
> anything.
>
> I know there are plenty of threads on this in the oracle ngs, but I'd
> like something a bit more concrete to show to an ex-colleague who
> doesn't believe me.
>

I don't know that anyone would want to write a white paper just to attempt to convince people that "mixing table and index on the same device is no worse than separating them". What's the point? In fact, it's quite easy to see that mixing them up is no better than separating them assuming the same stripe degree.

Ask your colleague to visit this forum and read what people say about how disks work in what configuration, and in what circumstances you get or don't get performance benefit. That and a little thinking, he will probably come to his own conclusion. Don't think this stuff is that hard to understand. It will take some basic knowledge and reasonable common sense, but not much more than that.

> Thanks
>
> CE
Received on Fri Jun 28 2002 - 06:58:26 CEST