Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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)

Re: Oracle's tuning guidelines (Was: Re: Need suggestions for filesystem config, spindle separation, striping for HP-UX/PeopleSoft)

From: John K. Hayes <aikosys_at_earthlink.net>
Date: Mon, 26 Feb 2001 20:26:55 GMT
Message-ID: <3A9ABC32.983F4CFB@earthlink.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US