SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

UPDATE STATISTICS Messages (9200 through
9225)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
11-6
Effect. The operation fails.
Recovery. Execute either a DELETE statement or a PURGEDATA command on the
table and resubmit.
SQL 9220
where,
table-name is the name of a SQL/MX table.
Cause. The user-specified sample table has either an index or a trigger or both. An
index on the sample table might prevent the use of Side-tree inserts for populating the
sample table and degrade performance. A trigger could modify the inserted data in an
undesirable way, besides degrading performance.
Effect. The operation fails.
Recovery. Drop all the indexes and triggers on the sample table and resubmit.
SQL 9221
where,
table-name is the name of a SQL/MX table.
Cause. Either the table for which the statistics have to be collected, or the user-
specified sample table, is not a SQL/MX table - it is either a SQL/MP table or some
other object such as, index or a view. The USING SAMPLE TABLE clause is supported
for SQL/MX tables only.
Effect. The operation fails.
Recovery. Specify a SQL/MX table name. For running the UPDATE STATISTICS
command on a SQL/MP table, do not use the USING SAMPLE TABLE clause.
SQL 9225
Cause. Histograms for the specified columns in the column-list are not available.
Effect. Processing continues.
Recovery. Run UPDATE STATISTICS command with column-list, and then rerun
the SHOWSTATS command.
9220 Sample table table-name cannot have index or trigger on
it.
9221 The specified table table-name is not a SQL/MX table.
9225 No histogram data is available for columns column-list.