Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle's tuning guidelines (Was: Re: Need suggestions for filesystem config, spindle separation, striping for HP-UX/PeopleSoft)
Sybrand Bakker wrote:
> >> For example, if a SQL statement uses two indexes at the same
time, then
> >> performance is improved by having each index on a separate
disk.
> >>
> >
> >But hey, didn't they just say "...can be stored on the same disk without
> >contention."
> >
> >Regards
> >/Fad
> >
>
> The last assertion before 'But hey' is also utter hogwash as that
> would mean all individual disks indexes on a separate spindles.
I think they're talking about striping the index tablespaces on multiple spindles, which does make sense. There's no need to put each index itself on a separate spindle. Received on Mon Feb 26 2001 - 14:26:55 CST