Documentation contradiction?

From: O'Neill, Sean <Sean.ONeill_at_organon.ie>
Date: Wed, 9 Aug 2000 15:51:01 +0200
Message-Id: <10584.114173@fatcity.com>

Hi Folks,

These excerpts from Oracle 8i documentation "appear" to be in contradiction to me. Seperate data and indexes on separate drives or not!. Am I correct or confusing apples and oranges so-to-speak.

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.

from
Oracle8i Tuning
Release 8.1.5
A67775-01
20
Tuning I/O

Place Datafiles Appropriately

Tablespace location is determined by the physical location of the datafiles that constitute that tablespace. Use the hardware resources of your computer appropriately.

For example, if several disk drives are available to store the database, it might be helpful to store table data in a tablespace on one disk drive, and index data in a tablespace on another disk drive. This way, when users query table information, both disk drives can work simultaneously, retrieving table and index data at the same time.

from
Administrator's Guide
Release 8.1.5
A67772-01
10
Managing Datafiles

Sean :)

######   ######  ######  ###### 
#    #   #    #  #    #  #    #  Rookie
####     #    #  ######  ######  Data
#   #    #    #  #    #  #    #  Base 
#    #  #######  ######  #    #  Adminstrator


-------------------------------- ------------

Organon (Ireland) Ltd.
E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]

The only man who never makes a mistake is the man who never does anything. Received on Wed Aug 09 2000 - 08:51:01 CDT