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

From: Jitendra Patel <coldrainandsnow_at_lycos.com>
Date: 9 Oct 2003 04:51:20 -0700
Message-ID: <7610580f.0310090351.1e152843@posting.google.com>

> > So I guess I can see why lots of people think that it's best to separate
> > indexes from tables. It doesn't mention that you should only separate them
> > for administration purposes mainly.

No, Eienstein. (I guess we know why you are unemployed).

Imaging a system on a single disk, with the index on the innermost cylinder and the data on the outermost cylinder.

During a index range scan, the disk will vibrate like unbalanced washing machine.

Try it on your PC, and you can watch this first hand. (If you actually own a computer, that is)

Yes, indexes belong on separate device, just like undo and online redo.

A single disk cannot write to two placed at once.

Had you any "real" experience, you would know that.

I'll bet TUSC does not offer you work.

Yeesh. Received on Thu Oct 09 2003 - 06:51:20 CDT