Oh brother....
Ok, assuming you have a single read/write arm and one read/write head (which is the
usual case), the arm has to go to the index location, read it, then go to the table
location and read that. If you perform several reads, it's going to go back and forth
between the index location and the table location. Having them on separate disks, and
hence separate read/write heads minimizes the back and forth movement, because on head
stays around the index, the other stays around the table. This movement, BTW, is
quite time consuming, relatively speaking.
>>> [EMAIL PROTECTED] 03/13/01 10:31AM >>>
Hi all,
I've read an interesting section in Oracle Docu (Tuning I/O):
---
Separating Tables and Indexes
It is not necessary to separate a frequently used table from its index.
During the course of a transaction, the index is read first, and then
the table is read. Because these I/Os occur sequentially, the table and
index can be stored on the same disk without contention.
---
Why do you then recommend to separate tables and indexes to different
disks?
Thanks
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michal Zaschke
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).