Re: Separating data, index objects

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Tue, 05 Jul 2005 00:20:36 GMT
Message-ID: <Xns9689B06D3450ESunnySD@68.6.19.6>

"Mark A" <nobody_at_nowhere.com> wrote in
news:epadnVAeuImRXlTfRVn-rQ_at_comcast.com:

>
> 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.

As a generalization the above is true.
However when Oracle decides to use an index, first the index is read and then then table is read. So for any single transaction ( without parallelization) the index & table are never read "at the same time". Received on Mon Jul 04 2005 - 19:20:36 CDT