sa_diagnostic_query table

The sa_diagnostic_query table is owned by the dbo user, and stores optimization information for queries, especially the context in which they were optimized. A row in this table represents an invocation of the optimizer for a query. Plans captured at optimization time are stored here.

Some of the values in this table mirror database option values.

There are two versions of this table: sa_diagnostic_query, and sa_tmp_diagnostic_query.

Columns

Column name	Column type	Description
logging_session_id	UNSIGNED INT	The ID of the logging session during which the query or request occurred.
query_id	UNSIGNED BIGINT	A number uniquely identifying the query.
statement_id	UNSIGNED BIGINT	A number uniquely identifying a statement in a query.
user_object_id	UNSIGNED BIGINT	The object ID of the user under which this query was executed. If the query was run from a procedure, this would be the user ID of the procedure owner.
start_time	TIMESTAMP	The time at which this query was optimized.
cache_size_bytes	UNSIGNED BIGINT	The size, in bytes, of the cache at the time this query was optimized.
optimization_goal	TINYINT	Determines whether query processing is optimized towards returning the first row quickly, or minimizing the cost of returning the complete result set. This value reflects the value of the optimization_goal database option. To see possible values for this column, see optimization_goal option.
optimization_level	TINYINT	Controls the amount of effort made by the SQL Anywhere query optimizer to find an access plan for a SQL statement. This value reflects the value of the optimization_level database option. To see possible values for this column, see optimization_level option.
user_estimates	TINYINT	Controls whether user selectivity estimates in query predicates are respected or ignored by the query optimizer. This value reflects the value of the user_estimates database option. To see possible values for this column, see user_estimates option.
optimization_workload	TINYINT	Determines whether query processing is optimized towards a workload that is a mix of updates and reads or a workload that is predominantly read-based. This value reflects the value of the optimization_workload database option. To see possible values for this column, see optimization_workload option.
available_requests	TINYINT	Used internally to compute the level of intra-query parallelism.
active_requests	TINYINT	Used internally to compute the level of intra-query parallelism.
max_tasks	TINYINT	Used internally to compute the level of intra-query parallelism.
used_bypass	TINYINT	Whether a simple query bypass was used. A value of 1 indicates a bypass was used; a value of 0 indicates that the query was fully optimized.
estimated_cost_ms	TINYINT	The estimated cost, in milliseconds.
plan_explain	LONG VARCHAR	A text plan representation of this query.
plan_xml	LONG VARCHAR	A graphical plan representation of the query (if one was recorded).
sql_rewritten	LONG VARCHAR	Text of a query after applying optimizations. A value will only be present in this column if optimization logging is enabled.

sa_diagnostic_query table

Columns

See also