The following capabilities are not supported:
- Use of AS clause
- Use of expression stats
- COLLECT SUMMARY STATS (there is no table-level stats collection with OTF tables. That is, there is no stats entry row in DBC.StatsTbl, whose StatsId is 0)
- COLLECT sample stats
- COLLECT partition stats
- HELP CURRENT STATS
- SHOW CURRENT STATS
- SHOW IN XML STATS
- CREATE TABLE … WITH DATA AND STATS
- Stats collection on columns with LOB or VarByte data types