1     create table #similar(-- 0 Rows, Data: 0 B, Index: 0 B
2         id1 int not null,
3         id2 int not null,
4         type smallint not null
5     )
6     
7     
8     create clustered index ci_type on #similar_crby_sybsystemprocs__sp_cmp_all_qplans(-- 0 B refcount: 2
9         type DESC
10    )
11    create index nci_id1 on #similar_crby_sybsystemprocs__sp_cmp_all_qplans(-- 0 B refcount: 0
12        id1 DESC
13    )
14    create index nci_id2 on #similar_crby_sybsystemprocs__sp_cmp_all_qplans(-- 0 B refcount: 0
15        id2 DESC
16    )
17    

DEPENDENCIES

READERS AND WRITERS read_written by proc sybsystemprocs..sp_cmp_all_qplans