| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle's Myth: keep tables and indexes in separate tablespaces
"Geomancer" <pharfromhome_at_hotmail.com> wrote in message news:cf90fb89.0310100430.7c362905_at_posting.google.com...
> 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!
>
> Not sure why, maybe it's just a Windows thing.
Well, you go from a single spindle to 4 and you not sure why? :) and I'll bet with you that if you move your indexes back to the tables disk and leave everything else the same on the remaining two disks, you won't even notice any degradation!
-- Cheers Nuno Souto wizofoz2k_at_yahoo.com.au.nospamReceived on Sat Oct 11 2003 - 08:20:18 CDT
![]() |
![]() |