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

From: steve <me_at_me.com>
Date: Sat, 11 Oct 2003 16:53:28 +0800
Message-ID: <0001HW.BBADE6080002399FF0284600@news.newsguy.com>

On Fri, 10 Oct 2003 21:42:29 +0800, Richard Foote wrote (in message <9Hyhb.145121$bo1.92393_at_news-server.bigpond.net.au>):

> "Jack" <nn_at_mail.com> wrote in message news:Yryhb.263$3u.180_at_read3.inet.fi...

>> 
>> Look Howard what You did say at  23 Jun 2002 :
>> LOL
>> ------------------------------------------------
>> From: "Howard J. Rogers" <dba_at_hjrdba.com>
>> Newsgroups: comp.databases.oracle.server
>> Subject: Re: Basic question on RAID array / Tablespace configuration.
>> Date: Sun, 23 Jun 2002 00:33:46 +1000
>> 
>> There is precisely zero benefit in separating tables from their indexes

> for

>> performance reasons. Both are segments. Just like Table A and Table B are
>> both segments. Separate A from B by all means, but unless you're

> consistent,

>> there's no point in separating a table from its index.
>>

>
> Hi Jack,
>
> That's great, it really is, that's really really funny (excuse me while I
> wipe tears away).
>
> Ummmm, while I'm trying to compose myself here, could you please just remind
> me exactly why it is so funny.
>
> Howard's been consistent in what he's been saying, and .....
>
> I feel all embarrassed now but I actually don't get it !!
>
> ?????
>
> Richard
>
>
>

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:

in separate segmnents on the same disk.
in sequential disk blocks within the same oracle segment
on seperate disks on the same controller.
on separate disks on different controllers.

it seems that people are assuming different conditions, based on their experience.
even the guy who thinks that you can only write to a disk in a singularity, but perhaps hes only ever used single head, single analog port disk drives.

The training material is partly at fault for not clearly describing the physical hardware configuration, without which we can all argue that oranges look like apples. Received on Sat Oct 11 2003 - 03:53:28 CDT