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 |
Reserved. |
text |
varchar(255) |
The SQL text, if type is 10, or the abstract query plan text, if the type is 100. |
Unique clustered index On uid, gid, hashkey, id, type, sequence
