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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle's Myth: keep tables and indexes in separate tablespaces

Re: Oracle's Myth: keep tables and indexes in separate tablespaces

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 11 Oct 2003 12:51:40 +0100
Message-ID: <3f87eeb5$0$264$cc9e4d1f@news.dial.pipex.com>


"steve" <me_at_me.com> wrote in message
news:0001HW.BBADE6080002399FF0284600_at_news.newsguy.com...
> I think we all need to be a little clearer on what we are saying.
>
> when we are saying separate tables and indexes, do we mean:
>
> 1. in separate segmnents on the same disk.
> 2. in sequential disk blocks within the same oracle segment
> 3. on seperate disks on the same controller.
> 4. on separate disks on different controllers.

Um well as tables and indexes are both types of segment 1 and 2 are nonsensical statements. Did you perhaps mean tablespace or something else instead of segment?

The myth is that just by putting data and indexes in seperate tablespaces performance improves. This is demonstrably untrue. Putting contending segments (which tables and their indexes may be) on different disks does improve performance but this is not the same thing.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Sat Oct 11 2003 - 06:51:40 CDT

Original text of this message

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