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

"Jitendra Patel" <coldrainandsnow_at_lycos.com> wrote in message news:7610580f.0310090351.1e152843_at_posting.google.com...

> 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.

REALLY? I'd say it is more than likely NOT in an index range scan that you'll get the "washing machine effect"...

> A single disk cannot write to two placed at once.

Brilliant deduction. With a tremendously risky extrapolation, I'd hazard a wild guess that it can't read from two places at once either...

Yet, I thought the OP (and you) were talking about "reading" index values and table values? Since when is an index range scan a "write to two placed at once"?

> Yeesh.

Indeed...

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam