Neoview Workload Management Services Guide (R2.5)

B Query Types Managed by WMS
This table lists the types of queries that run on the Neoview platform and whether they are
managed by WMS. The STATEMENT_TYPE field, which contains a compiler-provided value,
appears in the output of the STATUS QUERIES command with the ALL STATS option.
Table B-1 Query Types Managed by WMS
Managed by WMSSQL StatementsSTATEMENT_TYPE
Yes, only when
query statistics
aggregation is
enabled
• SELECT statements that operate on a single row
• TABLE statements that operate on a single row
SQL_SELECT_UNIQUE
Yes• SELECT statements that operate on multiple rows
• TABLE statements that operate on a single row
• EXPLAIN statement
SQL_SELECT_NON_UNIQUE
Yes, only when
query statistics
aggregation is
enabled
• INSERT statements that operate on a single row
• VALUES statements that operate on a single row
SQL_INSERT_UNIQUE
Yes• INSERT statements that operate on multiple rows
• VALUES statements that operate on multiple rows
SQL_INSERT_NON_UNIQUE
Yes, only when
query statistics
aggregation is
enabled
• UPDATE statements that operate on a single row
• MERGE INTO statement
SQL_UPDATE_UNIQUE
Yes• UPDATE statements that operate on multiple rowsSQL_UPDATE_NON_UNIQUE
Yes, only when
query statistics
aggregation is
enabled
• DELETE statements that operate on a single rowSQL_DELETE_UNIQUE
Yes• DELETE statements that operate on multiple rowsSQL_DELETE_NON_UNIQUE
Yes• CALL statements that do not return result setsSQL_CALL_NO_RESULT_SETS
Yes• CALL statements that return result setsSQL_CALL_WITH_RESULT_SETS
Yes• Utility commands such as POPULATE INDEXSQL_CAT_UTIL
Yes• MAINTAIN command (REORG, UPDATE STATISTICS,
or REFRESH tasks)
• REPLICATE command
• PURGEDATA utility
SQL_EXE_UTIL
Yes• Insert commands during a load jobSQL_EXEC_INSERT_RWRS
No• CONTROL QUERY DEFAULT statementSQL_CONTROL
No• SET TRANSACTION statementSQL_SET_TRANSACTION
No• SET CATALOG statementSQL_SET_CATALOG
No• SET SCHEMA statementSQL_SET_SCHEMA
No• ALTER/CREATE/DROP statements
• GRANT/REVOKE statements
• BEGIN/COMMIT/ROLLBACK WORK statements
• UPDATE STATISTICS statement
SQL_OTHER
261