Stuck between a rock and an IO Bottleneck

From: Mike Jones <Mike_at_mikejones.fsnet.co.uk>
Date: 28 Oct 1999 19:32:17 GMT
Message-ID: <01bf217a$32eec9e0$ae95883e_at_mikejones.fsnet.co.uk>

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 Received on Thu Oct 28 1999 - 21:32:17 CEST