Bernie: I'll bet dollars to donuts this is an indexing issue.
Is CreditDate indexed? If so, try dropping the index and repeating the command (which will run more slowly). In fact, try projecting a completely unindexed copy of the table and operating on that. Also, look for CreditDate used in a multi-column index. -- Larry

