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.

dbid

int null

For future use only

qpdate

datetime null

For future use only

sprocid

int null

For future use only

hashkey2

int null

For future use only

key1

int null

For future use only

key2

int null

For future use only

key3

int null

For future use only

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.

Indexes