Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle PQO
Robert Miller wrote:
>
> Michael Ho wrote:
> >
> > David Zhu wrote:
> > >
> > > I am looking for any guildline for implement Oracle Parallel Query
> > > Option. The benchmark result was not very good comparing to queries
> > > which use indexes. Any advice will be appreciated.
> >
> > Difficult to tell, how exactly you benchmark ?
> > Have you reference the Oracle manual ?
>
> The Parallel Query Option is no longer an option, but along with
> Distributed Option is bundled with 7.3 RDBMS. And the effect it has on
> benchmarks is fabulous. Check out WWW.TPC.ORG
Parallel Query Option works great in practice, too. For example, it
made short work (40 minutes)of queries against a 16 Gb table that
previously ran all day without completing. Environment: Sun E2000 with
8 processors. Bryan
Received on Wed Apr 09 1997 - 00:00:00 CDT