## ColumnName

- If more than one column or expression is specified, each column or expression is separated by a comma.
- The maximum number of columns is 64.
- If expressions are in the list, the maximum number of columns can be reduced past the limit of 64, depending on the combined total size of the text in the expressions.
- If the combined total size of the expression text causes the maximum column limit to be less than the actual number of columns in the list, an error occurs.

## FieldIdList

The FieldIdList column is NULL for fields that involve expressions.

## MaxInterval and MaxValueLength

If these statistics are collected with system determined maximum intervals and maximum value length, the MaxInterval and MaxValueLength columns are NULL.

## Possible Values for StatsType

Value | Description |
---|---|

T | Table |

I | Join Index |

N | Hash Index |

V | View |

Q | Query |

L | Link Row |

## SampleSizePct

If sampling is not used, the SampleSizePct column is set to 0 or 100.

## StatsSource

The StatsSource column records the method by which this statistic is acquired. For information about the possible values for the StatsSource column, see "StatsSource Column."