I need to perform many update queries on the same table
sporting 1 Mio rows.
It is not possible to do all updates in one query, I
definitely need several queries.
On the other hand, in each update query, I'd rather update
only about 20,000 rows at a time to avoid ing the log
The "top 20000" or "set rowcount 20000" methods don't seem
to help the optimiser, probably because the update queries
are joined, like in:
SET OrderType = "unknown"
LEFT JOIN OrderTypes
ON Orders.OrderType = OrderTypes.OrderType
WHERE OrderTypes.OrderType IS NULL
I have an ...