sysquerymetrics  sysreferences

Chapter 1: System Tables

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 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





Copyright © 2005. Sybase Inc. All rights reserved. sysreferences

View this book as PDF