Re: Separating data, index objects

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Wed, 06 Jul 2005 12:49:39 GMT
Message-ID: <DrQye.16445$oJ.2781@news-server.bigpond.net.au>

"Paul" <paul_at_see.my.sig.com> wrote in message news:o6inc1hh2sl74h8hi0g32v36jfdi0a00m6_at_4ax.com...
>
>
>
> DA Morgan <damorgan_at_psoug.org> wrote:
>
>>Separation of tables and indexes serves no useful purpose with respect
>>to scalability and performance.
>
>
> Forgive me for jumping in here, but *_a priori_*, it seems obvious
> that it *_should_* serve such a purpose.
>
>
> What is the mechanism by which Oracle prevents this from happening?
>
>
> Here, we are talking about tableX with indexX, but it does still make
> sense to separate different tables and indices to avoid contention -
> or is this not correct either?
>
>
> Refs and URL's appreciated.

Hi Paul,

Read my other post in the thread (just posted) and hopefully it might help to answer your question.

Cheers

Richard Received on Wed Jul 06 2005 - 07:49:39 CDT