sysqueryplans

All databases

sysqueryplans contains two or more rows for each abstract query plan. Uses datarow locking.

The columns for sysqueryplans are:

Name	Datatype	Description
uid	int	User ID of user who captured the abstract plan.
gid	int	The abstract plan group ID under which the abstract plan was saved.
hashkey	int	The hash key over the SQL query text.
id	int	The unique ID if the abstract plan.
type	smallint	10 if the text column contains query text, or 100 if the text column contains abstract plan text.
sequence	smallint	Sequence number if multiple rows are required for the text of the SQL query or abstract plan.
status	int null	Reserved.
text	varchar(255) null	The SQL text, if type is 10, or the abstract query plan text, if the type is 100.