Updating Statistics for Columns

The Table and Column Scope specification can also include the names of 3one or more columns for which you want distributions calculated. For example, 3this statement calculates the distributions for three columns of the orders table:

UPDATE STATISTICS FOR TABLE orders (order_num, customer_num, ship_date)

If you include no column name in the FOR TABLE 3clause, then distributions are calculated for all columns of the specified table, using to the LOW, MEDIUM, or HIGH mode and the 3RESOLUTION percentage that you request. .

Distributions are not calculated for BYTE or TEXT columns. See also Updating Statistics for Columns of User-Defined Types (IDS) for UPDATE STATISTICS restrictions 3on columns that store UDTs.