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

From: Hulse <hulse_kevin_at_yahoo.com>
Date: 13 Oct 2003 12:03:31 -0700
Message-ID: <16926526.0310131103.441f319@posting.google.com>

pharfromhome_at_hotmail.com (Geomancer) wrote in message news:<cf90fb89.0310100430.7c362905_at_posting.google.com>...
> > No, Eienstein. (I guess we know why you are unemployed).
>
> Um, had you made several caveats and been less insulting, your point
> might have been better taken.
>
> If the disk is not RAID striping (RAID10, 0+1, 5) then many of your
> points may be correct.
>
> In my experience with Oracle on Windows, I demonstrated significant
> slowdown with the whole database on a single non-RAID disk.
>
> When I moved indexes to a separate disk, undo to another and redo to a
> 4th disk, performance doubled!

This hardly demonstrates anything. You altered a number of things to generate the 100% performance improvement. The improvement could have been a result of isolating only a subset of those files.

>
> Not sure why, maybe it's just a Windows thing.
Received on Mon Oct 13 2003 - 14:03:31 CDT