Optimizer Messages (6000 through 6999)
HP NonStop SQL/MX Messages Manual—640324-001
8-3
Recovery. None.
SQL 6008
Where column-name is the name of the affected column.
Where table-name is the name of the SQL/MX table to which the columns belong.
Cause. Statistics for the column were not generated.
Effect. None. The plan generated by the optimizer might not be optimal. This is a
warning message.
Recovery. Generate the statistics for the column identified in the warning, and prepare
the query again.
SQL 6020
Cause. The defaults attribute MEMORY_USAGE_SAFETY_NET is set and the
MXCMP process memory reached the set threshold.
Effect. This is a warning message. SQL/MX optimizer has reached the set threshold
and the query plan generated might be sub-optimal. As a result, there may be a slow
execution of the query.
Recovery. None.
6008 Statistics for column column-name from table table-name
were not available. As a result, the access path chosen might
not be the best possible.
6020 Optimizer has reached its memory threshold; the query
plan generated might not be optimal.
To Next Page