Database	Table	Application	Created	Links
sybsystemprocs	sysqueryplans		31 Aug 14	Joins Schema ColumnUsage Queries Dependencies

1     create table sysqueryplans(-- 0 Rows, Data: 2 KB, Index: 6 KB
2         uid int not null,
3         gid int not null,
4         hashkey int not null,
5         id int not null,
6         type smallint not null,
7         sequence smallint not null,
8         status int null,
9         text varchar(255) null,
10        dbid int null,
11        qpdate datetime null,
12        sprocid int null,
13        hashkey2 int null,
14        key1 int null,
15        key2 int null,
16        key3 int null,
17        key4 int null
18    )
19    
20    create unique clustered index csysqueryplans on sysqueryplans(-- 2 KB refcount: 100
21        uid, gid, hashkey, id, type, sequence
22    )
23    create unique index ncsysqueryplans on sysqueryplans(-- 2 KB refcount: 8
24        id, type, sequence
25    )
26    
27    alter table sysqueryplans lock datarows
28    
29    Grant Select on sysqueryplans to public
30    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_cmp_qplans      called by proc sybsystemprocs..sp_copy_qplan         called by proc sybsystemprocs..sp_copy_all_qplans   read_written by proc sybsystemprocs..sp_import_qpgroup   read_written by proc sybsystemprocs..sp_backup_metrics      called by proc sybsystemprocs..sp_metrics   read_written by proc sybsystemprocs..sp_drop_query_tuning      called by proc sybsystemprocs..sp_query_tuning   read_written by proc sybsystemprocs..sp_copy_qplan   read_written by proc sybsystemprocs..sp_drop_all_qplans   read by proc sybsystemprocs..sp_find_qplan   read by proc sybsystemprocs..sp_help_qplan      called by proc sybsystemprocs..sp_cmp_all_qplans   read by view sybsystemprocs..sysquerymetrics      read by proc sybsystemprocs..sp_show_metrics         called by proc sybsystemprocs..sp_metrics   written by proc sybsystemprocs..sp_drop_qplan   read by proc sybsystemprocs..sp_show_query_tuning      called by proc sybsystemprocs..sp_query_tuning   read by proc sybsystemprocs..sp_cmp_all_qplans   read by proc sybsystemprocs..sp_help_qpgroup   read_written by proc sybsystemprocs..sp_drop_metrics      called by proc sybsystemprocs..sp_metrics   read by proc sybsystemprocs..sp_filter_metrics      called by proc sybsystemprocs..sp_metrics   read by proc sybsystemprocs..sp_drop_qpgroup   read by proc sybsystemprocs..sp_copy_all_qplans   read_written by proc sybsystemprocs..sp_set_qplan