parallel query

From: Dean <d.j.l_at_btinternet.com>
Date: Fri, 18 Aug 2000 23:42:02 +0100
Message-ID: <8nkb0a$e19$1@neptunium.btinternet.com>

Hi,
can any shed some light on the following.

PQ seems to work fine on fact table. ie
select sum(sales), t_id from fact group by t_id PQ gives me 4 fold increase in performance. However..
select sum(f.sales), d.t_id from fact f, dimension d where f.t_id=d.t_id
group by d.t_id

this leads to serious degradition with shed-loads of io (which is'nt reported in tkprof stats)
Oracle support have had this tar going for 2 months with no joy (quelle surprise)

any help is gratefully appreciated

Cheers

Dean Received on Fri Aug 18 2000 - 17:42:02 CDT