Minor Description
When UPDATE STATISTICS creates a persistent sample table, it uses CREATE TABLE LIKE, which means that the sample table will get LOB columns even though we don't support statistics on LOBs. Moreover, we will populate these LOB columns. This is an unnecessary overhead.
We could improve the efficiency of UPDATE STATISTICS on tables with LOB columns by omitting the LOB columns when creating the sample table, and omitting the logic to populate them.
Attachments
Issue Links
- links to
