Posted by othellomy on 12/04/06 03:52

> with 50K rows, this takes about 5 minutes. However I have almost
> 9,000,000 rows of history. (15 years of 4 quarter sessions). If this
> build is linear, it would take 1.25 hours.

Your update clause is way to complex and I think you should be very
lucky if you can get an answer in 1.5 hours for 9 million records (you
can use all the indexes in the world). My best estimation is it will
take more than 24 hours which is unrealistic.

[Back to original message]