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 PQO

Re: Oracle PQO

From: Bryan Warfield <Bryan.Warfield_at_DAL.frb.org>
Date: 1997/04/09
Message-ID: <334BF6F7.6448@DAL.frb.org>#1/1

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

Original text of this message

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