Major Description
UPDATE STATISTICS attempts to use an internal sort when possible. It estimates how much memory it has available to it, and estimates how much memory is needed to store the sample data. It then attempts to allocate this memory. If it fails to get everything it needs, it appears to retain what memory it has allocated, but then runs a sample table load query. Thus, memory has been allocated in the master executor process that might have been useful to the load query. It would have been better perhaps to release this memory, and attempted to reaquire it later.
Attachments
Issue Links
- links to
