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: Parallel query

Re: Parallel query

From: koert54 <koert54_at_nospam.com>
Date: Mon, 03 Dec 2001 17:50:52 GMT
Message-ID: <0YOO7.14975$Xh.4006084815@hebe.telenet-ops.be>

You must be a developer - you think too much in number of records instead bytes ... I only consider PQ when a table is above 5GB and I can spread the table over multiple disks ... I just say a figure (5GB) but it all depends on what kind of hardware you have ...

"Michiel Brunt" <mbrunt_at_inergy.nl> wrote in message news:9uflsc$d0m$1_at_scavenger.euro.net...
> We use Oracle 8i for a data warehouse. There is a large (>20 mln) fact
table
> and smaller dimension tables (max 100.000).
> Parallel processing should be useful, but what tables should be altered
for
> parallel query?
> Thanks
> Michiel
>
>
Received on Mon Dec 03 2001 - 11:50:52 CST

Original text of this message

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