RE: Tables and indexes on different disks

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Tue, 13 Mar 2001 09:34:29 -0800
Message-ID: <F001.002CB156.20010313092722@fatcity.com>

This is interesting.

Where did you find this, exactly?

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>

        -----Original Message-----
        From:   Michal Zaschke [SMTP:zaschke_at_suas.cz]
        Sent:   Tuesday, March 13, 2001 11: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: zaschke_at_suas.cz

        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: ListGuru_at_fatcity.com (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: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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: ListGuru_at_fatcity.com (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). Received on Tue Mar 13 2001 - 11:34:29 CST