Posted by nnelson on 02/25/06 17:41

The CustomerActivity record has a clustered index of CustomerActivityId
and Unique NonClustered index of CustId, ActivityDate and ActivityType.
The order table does not have an index on CustId. It has a unique non
clustered index on OrderNumber and OrderDate. And another index on
OrderId.

SQL 2000 would never take this long, even with the current
setup...maybe 5 minutes. I just can't understand it.

[Back to original message]