Re: Separating data, index objects

Mark A wrote:

>>>Depends on your bufferpool hit ratio (which depends mostly on the size of
>>>bufferpool relative to total amount of data/indexes).
>>
>>"DA Morgan" <damorgan_at_psoug.org> wrote in message
>>news:1120514204.987114_at_yasure...
>>What does this have to do with the OP's question? And what is the source
>>of the information?
>>
>>Separating them has no impact on performance but makes using
>>transportable tablespaces a bit more complex.
>>
>>Daniel A. Morgan

> 
> 
> In theory, if the table data and index data are in the same tablespace, the 
> disk contention could occur if there was a significant amount of I/O against 
> the table and index at the same time.

Wholesale nonsense. And let me refer you to Jonathan Lewis, Richard Foote, and Howard Rogers who have beaten this dead horse into dog meat repeatedly in this forum.

Sorry Mark but that is pure unadulterated mythology disproven over and over and over again.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)