sysqueryplans

All databases

Description

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

Columns

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

Reserved.

text

varchar(255)

The SQL text, if type is 10, or the abstract query plan text, if the type is 100.

Indexes

Unique clustered index On uid, gid, hashkey, id, type, sequence

Nonclustered unique index On id, type, sequence