Data Warehouse Summary Table Problem

I work on a data warehouse, on an Oracle 7.3 for NT platform. I am creating summary tables that get re-populated every night. The code that performs this goes as follows:

  	     Truncate table
                   insert into table 


                   (select col1, col2...  from view)

This code works fine for all summary tables except 1. The code for populating this rather small summary table from a view will hang for hours. The stumper is that when a execute the following code it will finish in 30 seconds.

	      drop table 
                   create table as 


                   (select col1, col2...  from view)

The explain plan on these two statements are essentially the same.

Any ideas? Received on Sat May 10 1997 - 00:00:00 CDT