Mike,
It becomes more of a problem with inserts/updates. If you update a column that is indexed, or insert a record, the table is updated and the index is updated simultaneously. If the table and index(es) are both on the same disk, you will see contention.
Of course there are "exceptions" to the rule. The one I am aware of is if your database resides on EMC disks. The underlying cache can minimize contention.
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
From: Michal Zaschke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
Subject: Tables and indexes on different disks
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).
