Re: IO Bottleneck won't go away

From: <michael_bialik_at_my-deja.com>
Date: Fri, 29 Oct 1999 14:55:35 GMT
Message-ID: <7vcch4$qr1$1@nnrp1.deja.com>

Hi.

Is it possible to post the EXPLAIN of SELECT part and the number of rows in the outerjoined table as well?

Michael.

In article <01bf2191$1004fc80$cf82883e_at_mikejones.fsnet.co.uk>, "Mike Jones" <Mike_at_mikejones.fsnet.co.uk> wrote:
> I'm currently experiencing a very annoting IO Bottle neck.
>
> While running a "create as select" I experience massive IO
bottleneck.
> This is unsurprising given the size of the Tables I am Joining (1
mill rows
> * 4 tables) three tables are outerjoined to the same main table.
>
> In order to speed this up I took the recommended action of creating
Indexes
> on the tables to be outer joined. However the index creation takes
an age
> due to the amount of IO they cause. I've tried creating these in
parallel
> to see if that helped, but the IO Bottleneck means that the overall
> performance is virtually unaffeted.
>
> All I am currently able to do is move the bottleneck around and so
gain no
> perfomence improvement.
>
> any ideas??
>
> This query is running on Oracle 734
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 29 1999 - 09:55:35 CDT