Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: should you seperate indexes from tables in seperate datafiles

RE: RE: should you seperate indexes from tables in seperate datafiles

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Tue, 15 Jul 2003 12:25:28 -0500
Message-Id: <25929.337859@fatcity.com>


If you can't find it, you can download it again from http://www.hotsos.com/catalog. I *promise* I haven't cheated and edited the document since the date that's published on its cover.

Lots of people at the time (~1992) were preaching to separate indexes and data on different disks. The OFA gave you the *ability* to separate indexes from data on disk (if your I/O rates were high enough to motivate it), but I tried to avoid saying anything in that document that either wasn't true to begin with, or that was likely change as technology evolved.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:

- Hotsos Clinic 101 in Washington, Denver, Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-----Original Message-----
From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On Behalf Of Rachel Carmichael
Sent: Tuesday, July 15, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L Subject: RE: RE: should you seperate indexes from tables in seperate datafiles

if I can still find it. :) I know Kevin did say "different disks" because I remember coming home from that presentation and trying to explain to my data center people why I needed something like 17 disks for my database.

my apologies.... over the years, people have made the assumption that different tablespaces=different disks


Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
Received on Tue Jul 15 2003 - 12:25:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US