QPRI 3 Join or Sarg with Rooted Partial Index Use


SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_activeroles:78
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_activeroles:175
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_add_qpgroup:105
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_add_resource_limit:617
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_addengine:149
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_addengine:157
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_addengine:168
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_addengine:195
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_addengine:202
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_addexeclass:140
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_addexeclass:184
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_addexeclass:194
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_addexeclass:215
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_addexeclass:253
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addexternlogin:170
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addexternlogin:190
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_info2, object_info1, object, class}
sybsystemprocs..sp_addexternlogin:355
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_info2, object_info1, object, class}
sybsystemprocs..sp_addexternlogin:457
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addgroup:121
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addlanguage:113
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addlanguage:180
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addlogin:224
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addlogin:243
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute, object_cinfo}
sybsystemprocs..sp_addlogin:319
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, object_cinfo}
sybsystemprocs..sp_addlogin:605
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_addmessage:67
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addobjectdef:155
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_cinfo, attribute, class}
sybsystemprocs..sp_addobjectdef:183
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addremotelogin:268
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_addsegment:125
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_addsegment:129
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addsegment:158
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addsegment:188
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addsegment:226
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addsegment:239
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addsegment:340
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addserver:174
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addserver:248
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_addserver:313
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_addserver:345
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_addserver:382
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_addserver:393
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_addserver:607
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_addthreshold:84
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addthreshold:193
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addthreshold:314
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addtype:186
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addumpdevice:39
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addumpdevice:50
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_adduser:135
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_altermessage:41
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_altermessage:93
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_altermessage:110
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_altermessage:127
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_autoformat:363
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_aux_computeprivs:173
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action, id}
sybsystemprocs..sp_aux_computeprivs:183
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_aux_computeprivs:911
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_aux_encr_verify_downgrade:266
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_aux_get_concrtlyownedobj:15
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_aux_get_concrtlyownedobj:64
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_aux_get_qpgroup:31
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_aux_securityprofile_getattr:20
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_aux_securityprofile_getattr:27
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_aux_securityprofile_getattr:30
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_aux_sys_encr_passwd_lookup:15
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_bindcache:335
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_bindcache:420
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_bindcache:430
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {id, sequence}
sybsystemprocs..sp_bindefault:135
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_bindefault:139
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindefault:162
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindefault:164
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindefault:180
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindefault:198
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindefault:213
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindefault:228
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_bindexeclass:180
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_bindexeclass:199
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..sp_bindexeclass:294
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..sp_bindexeclass:302
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..sp_bindexeclass:326
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_bindexeclass:353
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_bindexeclass:361
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_bindexeclass:385
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_bindexeclass:413
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_bindexeclass:419
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, attribute, class}
sybsystemprocs..sp_bindexeclass:439
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_info1, object_cinfo, object, class}
sybsystemprocs..sp_bindexeclass:468
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_info1, object_cinfo, object, class}
sybsystemprocs..sp_bindexeclass:477
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_info1, object_cinfo, object, class}
sybsystemprocs..sp_bindexeclass:501
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_bindexeclass:531
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_bindexeclass:538
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_bindexeclass:561
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {id, sequence}
sybsystemprocs..sp_bindrule:157
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindrule:180
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindrule:182
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindrule:204
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindrule:223
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindrule:239
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindrule:257
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindrule:303
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindrule:322
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_bindrule:333
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:316
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1386
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1481
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1547
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1619
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1697
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1733
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1741
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_changegroup:313
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_checknames:306
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_checknames:320
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_checkreswords:47
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_checkreswords:71
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_checkreswords:91
JOIN Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
Uncovered: [uid]
sybsystemprocs..sp_checkreswords:160
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_checkreswords:414
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_checkreswords:431
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_chgattribute:398
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_chgattribute:404
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_chgattribute:609
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_chgattribute:633
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_chgattribute:735
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_chgattribute:845
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_chgattribute:852
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_chgattribute:921
SARG Candidate index: syscharsets.csyscharsets unique clustered
(id, csid)
Intersection: {id}
sybsystemprocs..sp_chklangparam:60
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_clearpsexe:129
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_clearpsexe:149
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {uid, type, hashkey, sequence}
Uncovered: [id]
sybsystemprocs..sp_cmp_all_qplans:110
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_column_privileges:141
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_column_privileges:166
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:184
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:186
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:207
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:209
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:232
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:234
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:257
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:259
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:282
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:284
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:307
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:309
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:332
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:334
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:357
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_commonkey:359
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_config_rep_agent:114
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_config_rep_agent:726
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_config_rep_agent:793
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_config_rep_agent:899
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_config_rep_agent:923
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
sybsystemprocs..sp_configure:304
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
sybsystemprocs..sp_configure:318
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
sybsystemprocs..sp_configure:350
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
sybsystemprocs..sp_configure:370
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_configure:450
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_configure:1029
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_configure:1523
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {uid, hashkey, gid}
sybsystemprocs..sp_copy_qplan:90
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_dboption:138
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object}
sybsystemprocs..sp_dboption:233
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:253
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:528
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:548
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:562
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:619
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:707
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_dboption_flmode:156
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_dboption_flmode:157
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class}
sybsystemprocs..sp_dboption_flmode:199
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_dboption_flmode:215
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_dboption_flmode:249
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_dbrecovery_order:216
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_dbrecovery_order:234
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_dbrecovery_order:245
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_dbrecovery_order:253
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, attribute, class}
sybsystemprocs..sp_dbrecovery_order:271
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, attribute, class}
sybsystemprocs..sp_dbrecovery_order:278
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_dbrecovery_order:312
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_dbrecovery_order:334
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_dbrecovery_order:340
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, attribute, class}
sybsystemprocs..sp_dbrecovery_order:354
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, attribute, class}
sybsystemprocs..sp_dbrecovery_order:360
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_dbrecovery_order:377
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, attribute, class}
sybsystemprocs..sp_dbrecovery_order:417
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_dbrecovery_order:453
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_dbrecovery_order:463
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_dbrecovery_order:481
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_dbrecovery_order:491
SARG Candidate index: syscharsets.csyscharsets unique clustered
(id, csid)
Intersection: {id}
sybsystemprocs..sp_default_charset:21
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_depends:84
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_depends:103
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {id}
sybsystemprocs..sp_depends:125
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_depends:137
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_depends:143
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {id}
sybsystemprocs..sp_depends:154
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {id}
sybsystemprocs..sp_depends:163
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_depends:185
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_depends:188
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_depends:191
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {id}
sybsystemprocs..sp_depends:193
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_depends:334
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_depends_cols:96
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_depends_cols:172
SARG Candidate index: sysreferences.nc2sysreferences
(reftabid, indexid, pmrydbname)
Intersection: {reftabid}
sybsystemprocs..sp_depends_cols:324
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_depends_cols:395
JOIN Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {id}
Uncovered: [number, type]
sybsystemprocs..sp_depends_cols:398
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_depends_cols:416
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_depends_cols:431
SARG Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {statid, id, formatid}
sybsystemprocs..sp_depends_cols:502
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {id}
sybsystemprocs..sp_depends_cols:604
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_displaylevel:129
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_displaylevel:175
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_displaylevel:182
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_cinfo, attribute, class}
sybsystemprocs..sp_displaylogin:308
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_displaylogin:313
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displaylogin:318
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_cinfo, attribute, class}
sybsystemprocs..sp_displaylogin:339
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_displaylogin:344
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displaylogin:349
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_cinfo, attribute, class}
sybsystemprocs..sp_displaylogin:353
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_displaylogin:358
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displaylogin:363
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_displaylogin:441
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_cinfo, attribute, class}
sybsystemprocs..sp_displayroles:298
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displayroles:306
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_cinfo, attribute, class}
sybsystemprocs..sp_displayroles:338
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displayroles:346
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_cinfo, attribute, class}
sybsystemprocs..sp_displayroles:360
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displayroles:368
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_displayroles:510
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_displayroles:562
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_displayroles:577
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_displayroles:647
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_displayroles:664
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_downgrade:326
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_drop_object:39
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_drop_object:43
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_drop_qpgroup:120
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_dropdevice:122
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_dropdevice:134
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_dropengine:114
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_dropengine:189
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info3, attribute, class}
sybsystemprocs..sp_dropengine:204
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_dropengine:265
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_dropengine:304
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_dropengine:324
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_dropexeclass:66
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_dropexeclass:97
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_dropextendedproc:52
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_info2, object_info1, object, class}
sybsystemprocs..sp_dropexternlogin:211
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_droplockpromote:180
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_droplockpromote:198
SARG Candidate index: sysresourcelimits.csysresourcelimits clustered
(name, appname)
Intersection: {name}
sybsystemprocs..sp_droplogin:454
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info1, object, class}
sybsystemprocs..sp_droplogin:494
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_droplogin:528
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_cinfo, attribute, class}
sybsystemprocs..sp_dropobjectdef:151
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_cinfo, attribute, class}
sybsystemprocs..sp_dropobjectdef:178
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_dropsegment:125
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_dropsegment:129
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:286
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:303
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:322
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_dropsegment:350
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:379
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:399
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_dropsegment:408
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:415
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:482
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:492
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:501
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_dropserver:170
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_dropserver:275
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_dropserver:320
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_dropserver:397
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_dropthreshold:63
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, object_info1}
sybsystemprocs..sp_dropuser:227
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, object_info1}
sybsystemprocs..sp_dropuser:366
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_drv_bcpmetadata:127
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_drv_bcpmetadata:156
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_drv_column_default:36
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_drv_column_default:45
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_drv_column_default:53
SARG Candidate index: syscharsets.csyscharsets unique clustered
(id, csid)
Intersection: {id}
sybsystemprocs..sp_drv_getsortorder:6
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_drv_getsortorder:6
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_encryption:197
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:374
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_encryption:703
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_encryption:742
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_encryption:769
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_encryption:1361
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:1372
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:1382
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:1393
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info2, class, attribute}
sybsystemprocs..sp_encryption:1412
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:1422
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:1442
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:1463
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_encryption:2115
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_encryption:2794
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:2815
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:2820
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info2, class, attribute}
sybsystemprocs..sp_encryption:2837
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:2865
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:2880
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_encryption:2895
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_estspace:270
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_estspace:276
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_estspace:513
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_extendsegment:117
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_extendsegment:121
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:169
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:186
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:203
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:341
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:361
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:388
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, class}
sybsystemprocs..sp_fix_dtm_ha_roles:64
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, class}
sybsystemprocs..sp_fix_dtm_ha_roles:73
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_fixindex:237
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_fixindex:351
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_fixindex:394
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_forceonline_db:40
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_db:120
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_db:138
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_db:155
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_forceonline_object:59
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_object:135
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_info2, object_info1, object, class}
sybsystemprocs..sp_forceonline_object:162
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_info2, object_info1, object, class}
sybsystemprocs..sp_forceonline_object:180
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_info2, object_info1, object, class}
sybsystemprocs..sp_forceonline_object:230
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_info2, object_info1, object, class}
sybsystemprocs..sp_forceonline_object:242
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_object:274
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_object:309
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_info2, object_info1, object, class}
sybsystemprocs..sp_forceonline_object:321
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_forceonline_page:52
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_page:125
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_page:152
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_page:168
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_page:216
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_page:227
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_page:256
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_page:289
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_forceonline_page:299
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_foreignkey:171
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_foreignkey:187
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_foreignkey:205
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_foreignkey:223
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_foreignkey:241
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_foreignkey:258
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_foreignkey:275
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_foreignkey:292
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:356
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:358
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:396
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:398
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:425
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:427
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:454
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:456
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:483
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:485
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:512
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:514
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:541
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:543
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:570
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_foreignkey:572
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_getmessage:39
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_getmessage:60
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_getmessage:66
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_getmessage:96
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_getmessage:102
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_getmessage:127
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ha_check_certified:18
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_help:91
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_help:136
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_help:327
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_help:354
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_help:374
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
Uncovered: [number]
sybsystemprocs..sp_help:466
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_help:485
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_help:603
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute, object_cinfo}
sybsystemprocs..sp_help:655
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
Uncovered: [attribute, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_help:721
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
Uncovered: [object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_help:722
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_help:739
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
Uncovered: [attribute, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_help:865
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
Uncovered: [object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_help:866
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_help:1041
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_help_params:29
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_help_params:38
JOIN Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {number}
Uncovered: [type]
sybsystemprocs..sp_help_params:76
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_help_params:77
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_help_params:83
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_help_qpgroup:67
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_help_rep_agent:60
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_helpartition:156
SARG Candidate index: syspartitionkeys.csyspartitionkeys unique clustered
(id, indid, colid)
Intersection: {id}
sybsystemprocs..sp_helpartition:226
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
Uncovered: [number]
sybsystemprocs..sp_helpartition:227
JOIN Candidate index: syspartitionkeys.csyspartitionkeys unique clustered
(id, indid, colid)
Intersection: {colid, id}
Uncovered: [indid]
sybsystemprocs..sp_helpartition:227
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_helpartition:305
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_helpartition:319
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_helpartition:348
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helpartition:437
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_helpartition:451
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helpartition:526
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_helpartition:573
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helpartition:607
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_helpartition:611
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helpartition:623
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {partitionid, id}
sybsystemprocs..sp_helpartition:651
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {id}
sybsystemprocs..sp_helpartition:663
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_helpartition:717
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_helpcache:159
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_helpcache:186
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpcomputedcolumn:106
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpcomputedcolumn:118
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_helpconfig:191
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpconfig:413
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpconstraint:150
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpconstraint:155
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpconstraint:217
SARG Candidate index: sysconstraints.csysconstraints clustered
(tableid, colid)
Intersection: {tableid}
sybsystemprocs..sp_helpconstraint:235
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpdb:69
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpdb:75
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_helpdb:239
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_helpdb:243
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdb:280
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdb:325
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdb:370
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdb:418
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_helpdb:455
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, object_info1}
sybsystemprocs..sp_helpdb:471
SARG Candidate index: sysusages.ncsysusages unique
(vdevno, vstart)
Intersection: {vdevno}
sybsystemprocs..sp_helpdb:544
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
Uncovered: [attribute, object, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_helpdb:613
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
Uncovered: [object, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_helpdb:614
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpdb:655
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdb:668
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpdb:751
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_helpdb:762
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpdb:775
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpdevice:24
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdevice:344
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdevice:438
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdevice:459
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdevice:480
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdevice:504
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdevice:561
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdevice:582
SARG Candidate index: sysusages.ncsysusages unique
(vdevno, vstart)
Intersection: {vdevno}
sybsystemprocs..sp_helpdevice:619
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpextendedproc:68
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type}
sybsystemprocs..sp_helpexternlogin:124
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_info2, class}
sybsystemprocs..sp_helpexternlogin:136
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type}
sybsystemprocs..sp_helpexternlogin:167
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_helpindex:331
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_helpindex:376
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_helpindex:404
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_helpindex:406
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpjava:34
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpjava:58
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel, langid]
sybsystemprocs..sp_helpjava:221
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel, langid]
sybsystemprocs..sp_helpjava:239
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel, langid]
sybsystemprocs..sp_helpjava:287
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel, langid]
sybsystemprocs..sp_helpjava:303
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpjava:365
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpjoins:236
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpjoins:237
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpjoins:245
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpjoins:246
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpjoins:269
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpjoins:270
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpjoins:284
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpjoins:285
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_helpobjectdef:145
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_cinfo, attribute, class}
sybsystemprocs..sp_helpobjectdef:170
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpremotelogin:133
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpremotelogin:174
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_helprotect:545
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {id}
sybsystemprocs..sp_helprotect:621
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {id}
sybsystemprocs..sp_helprotect:634
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid, id}
sybsystemprocs..sp_helprotect:646
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_helpsegment:99
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_helpsegment:114
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_helpsegment:156
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_helpsegment:166
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpserver:184
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpserver:434
SARG Candidate index: syscharsets.csyscharsets unique clustered
(id, csid)
Intersection: {id}
sybsystemprocs..sp_helpsort:77
SARG Candidate index: syscharsets.csyscharsets unique clustered
(id, csid)
Intersection: {id}
sybsystemprocs..sp_helpsort:88
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helptext:274
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {number, id}
sybsystemprocs..sp_helptext:291
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helptext:305
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helptext:331
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helptext:341
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helptext:353
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {number, id}
sybsystemprocs..sp_helptext:362
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_helpthreshold:30
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpuser:32
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpuser:136
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_ijdbc_aux_computeprivs:213
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action, id}
sybsystemprocs..sp_ijdbc_aux_computeprivs:222
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_ijdbc_aux_computeprivs:983
SARG Candidate index: syscharsets.csyscharsets unique clustered
(id, csid)
Intersection: {id}
sybsystemprocs..sp_ijdbc_default_charset:34
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:189
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:223
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:256
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:289
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:324
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_gettableprivileges:64
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_gettableprivileges:87
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_gettableprivileges:109
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_gettableprivileges:131
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_gettableprivileges:155
SARG Candidate index: spt_ijdbc_mda.spt_ijdbc_mda_ind unique
(mdinfo, mdaver_end, srvver_end)
Intersection: {mdinfo}
sybsystemprocs..sp_ijdbc_mda:86
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, uid}
sybsystemprocs..sp_import_qpgroup:86
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_index_row_size_est:121
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_indsuspect:108
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_inst15015msg_addlimsg:61
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_inst15015msg_addlimsg:90
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_inst15015msg_addlimsg:123
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_inst15015msg_addlimsg:454
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_inst15015msg_us_mesg:25
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_inst15015msg_us_mesg:43
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_jdbc_computeprivs:166
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action, id}
sybsystemprocs..sp_jdbc_computeprivs:176
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_jdbc_computeprivs:910
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_jdbc_fkeys:335
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_jdbc_getbestrowidentifier:37
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_jdbc_getbestrowidentifier:139
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_jdbc_getbestrowidentifier:186
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_jdbc_getbestrowidentifier:187
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_jdbc_getcolumnprivileges:278
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_jdbc_getcolumnprivileges:306
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action, id}
sybsystemprocs..sp_jdbc_getcolumnprivileges:315
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_jdbc_getcolumnprivileges:1018
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_jdbc_getindexinfo:169
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_jdbc_getversioncolumns:138
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:147
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:151
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:154
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:157
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:160
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:163
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:180
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:184
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:188
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:192
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:196
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:200
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:204
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:208
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:212
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_ldapadmin:336
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_ldapadmin:339
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:386
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_ldapadmin:390
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_listsuspect_db:42
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_listsuspect_db:50
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_listsuspect_db:59
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_listsuspect_db:65
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_listsuspect_object:42
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_listsuspect_object:76
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_listsuspect_page:42
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_listsuspect_page:78
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_locklogin:711
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_logdevice:161
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_logdevice:178
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_logdevice:203
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_logdevice:211
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_logintrigger:98
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_logintrigger:135
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_logintrigger:177
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_logintrigger:185
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_logiosize:287
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_logiosize:318
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_logiosize:333
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_makesuspect_obj:74
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_makesuspect_obj:148
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_info1, object, class}
sybsystemprocs..sp_makesuspect_obj:164
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, class, object, object_type, object_info1}
sybsystemprocs..sp_makesuspect_obj:253
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, class, object, object_type, object_info1}
sybsystemprocs..sp_makesuspect_obj:265
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, class, object, object_type, object_info1}
sybsystemprocs..sp_makesuspect_obj:275
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info2, attribute, class}
sybsystemprocs..sp_makesuspect_obj:296
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, class, object, object_type, object_info1}
sybsystemprocs..sp_makesuspect_obj:324
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_cinfo, attribute, class}
sybsystemprocs..sp_maplogin:342
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute, object_cinfo}
sybsystemprocs..sp_maplogin:347
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_cinfo, attribute, class}
sybsystemprocs..sp_maplogin:434
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute, object_cinfo}
sybsystemprocs..sp_maplogin:464
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_cinfo, attribute, class}
sybsystemprocs..sp_maplogin:483
SARG Candidate index: spt_mda.spt_mda_ind unique
(mdinfo, mdaver_end, srvver_end)
Intersection: {mdinfo}
sybsystemprocs..sp_mda:94
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_memlog:153
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type}
sybsystemprocs..sp_memlog:210
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_merge_dup_inline_default:462
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {id}
sybsystemprocs..sp_merge_dup_inline_default:518
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_merge_dup_inline_default:527
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute, object_cinfo}
sybsystemprocs..sp_modifylogin:389
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute, object_cinfo}
sybsystemprocs..sp_modifylogin:412
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_cinfo, attribute, class}
sybsystemprocs..sp_modifylogin:680
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_cinfo, attribute, class}
sybsystemprocs..sp_modifylogin:705
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_cinfo, attribute, class}
sybsystemprocs..sp_modifylogin:745
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object, attribute, class}
sybsystemprocs..sp_modifylogin:805
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_modifystats:153
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action, id}
sybsystemprocs..sp_modifystats:238
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_modifystats:329
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_modifystats:338
SARG Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray, id, formatid}
sybsystemprocs..sp_modifystats:345
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_modifystats:474
SARG Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {formatid, id}
sybsystemprocs..sp_modifystats:516
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_modifystats:544
SARG Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {formatid, id}
sybsystemprocs..sp_modifystats:612
SARG Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {formatid, id}
sybsystemprocs..sp_modifystats:622
SARG Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {formatid, id}
sybsystemprocs..sp_modifystats:667
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_modifythreshold:91
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_modifythreshold:271
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_mon_gen_columnlist:37
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_mon_gen_columnlist:96
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_monitor_getcfgnum:17
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_monitor_getcfgval:33
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_monitor_list:157
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_monitor_procedure:96
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_monitor_verify_setup:49
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_addtogroup:157
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_addtogroup:185
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_bind:310
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_bind:404
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_bind:418
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_creategroup:103
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_multdb_creategroup:124
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_dropgroup:114
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, class}
sybsystemprocs..sp_multdb_dropgroup:161
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_multdb_dropgroup:178
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_dropgroup:194
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_removefromgroup:147
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_removefromgroup:186
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_removefromgroup:193
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_multdb_show:130
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_show:146
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type}
sybsystemprocs..sp_multdb_show:159
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_cinfo, class}
sybsystemprocs..sp_multdb_show:183
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_cinfo, class}
sybsystemprocs..sp_multdb_show:202
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object, class}
sybsystemprocs..sp_multdb_show:217
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object, class}
sybsystemprocs..sp_multdb_show:235
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_cinfo, object, class}
sybsystemprocs..sp_multdb_show:250
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_cinfo, object, class}
sybsystemprocs..sp_multdb_show:271
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_unbind:251
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, class}
sybsystemprocs..sp_multdb_unbindall_db:149
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_multdb_unbindall_gr:97
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, class}
sybsystemprocs..sp_multdb_unbindall_gr:126
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_objectsegment:75
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_odbc_computeprivs:223
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action, id}
sybsystemprocs..sp_odbc_computeprivs:233
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_odbc_computeprivs:968
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_odbc_fkeys:379
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_odbc_getcolumnprivileges:145
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_odbc_getcolumnprivileges:170
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_odbc_getindexinfo:142
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_odbc_getversioncolumns:101
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_odbc_getversioncolumns:119
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_odbc_getversioncolumns:155
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_odbc_getversioncolumns:212
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_odbc_getversioncolumns:213
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_oledb_computeprivs:229
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action, id}
sybsystemprocs..sp_oledb_computeprivs:239
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_oledb_computeprivs:974
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_oledb_fkeys:371
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_oledb_getcolumnprivileges:135
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_oledb_getcolumnprivileges:144
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_oledb_getprocedurecolumns:47
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_oledb_primarykey:78
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_opt_querystats_main:471
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_opt_querystats_main:485
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_passwordpolicy:243
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_passwordpolicy:303
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_passwordpolicy:319
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_placeobject:183
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_placeobject:268
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_placeobject:288
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_placeobject:319
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_placeobject:351
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_placeobject:382
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_plan_dbccdb:134
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_plan_dbccdb:356
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_plan_dbccdb:384
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_plan_dbccdb:515
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
Uncovered: [number]
sybsystemprocs..sp_post_xpload:130
JOIN Candidate index: syspartitionkeys.csyspartitionkeys unique clustered
(id, indid, colid)
Intersection: {colid, id}
Uncovered: [indid]
sybsystemprocs..sp_post_xpload:130
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
Uncovered: [number]
sybsystemprocs..sp_post_xpload:149
JOIN Candidate index: syspartitionkeys.csyspartitionkeys unique clustered
(id, indid, colid)
Intersection: {colid, id}
Uncovered: [indid]
sybsystemprocs..sp_post_xpload:149
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_primarykey:140
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_primarykey:155
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_primarykey:172
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_primarykey:189
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_primarykey:206
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_primarykey:223
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_primarykey:240
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_primarykey:257
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_remoteoption:121
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_remoteoption:154
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_remoteoption:231
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_remoteoption:287
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_remoteoption:325
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_rename:118
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_rename:121
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_rename:267
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_rename:286
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_rename:389
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_rename:403
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_rename:680
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_rename:698
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_rename:709
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_info3, attribute, class}
sybsystemprocs..sp_rename:720
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_cinfo}
sybsystemprocs..sp_rename:853
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_rename_qpgroup:119
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_renamedb:112
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_replication_path:309
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_replication_path:420
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_replication_path:433
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_replication_path:471
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:534
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_replication_path:588
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:607
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_replication_path:675
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:701
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:712
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info2, class, attribute}
sybsystemprocs..sp_replication_path:732
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:745
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:755
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:778
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:783
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:788
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:823
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:828
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:833
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_replication_path:1124
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_replication_path:1152
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_replication_path:1416
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object, attribute, class}
sybsystemprocs..sp_replication_path:1533
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object, attribute, class}
sybsystemprocs..sp_replication_path:1615
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_reptostandby:112
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_rjs_register:109
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_rjs_register:111
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_rjs_retrieve:23
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_cinfo, class}
sybsystemprocs..sp_rjs_unregister:100
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_securityprofile:62
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_securityprofile:97
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_securityprofile:167
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_securityprofile:263
SARG Candidate index: syscharsets.csyscharsets unique clustered
(id, csid)
Intersection: {id}
sybsystemprocs..sp_serverinfo:64
SARG Candidate index: syscharsets.csyscharsets unique clustered
(id, csid)
Intersection: {id}
sybsystemprocs..sp_serverinfo:102
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setlangalias:86
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setlockpromote:329
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setlockpromote:428
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_setpsexe:188
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_setpsexe:235
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_setpsexe:244
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_setpsexe:271
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_setpsexe:278
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setrepcol:119
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:207
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:223
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:243
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:297
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:327
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:437
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:477
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:513
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:552
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setrepdbmode:130
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setrepdefmode:145
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setrepdefmode:519
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setreplicate:163
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_setreplicate:188
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setreplicate:254
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setreplicate:420
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setreplicate:444
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setreplicate:510
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setrepproc:192
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setrepproc:193
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepproc:554
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setreptable:195
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setreptable:613
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setreptable:702
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setreptable:715
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setsuspect_error:55
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_error:106
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_error:169
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_error:191
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_granularity:196
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_granularity:206
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_granularity:222
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_granularity:236
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_granularity:268
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setsuspect_threshold:55
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_threshold:106
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_threshold:178
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_threshold:203
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_threshold:210
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_setsuspect_threshold:233
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setup_table_transfer:50
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_shmdumpconfig:274
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_info1, attribute}
sybsystemprocs..sp_shmdumpconfig:281
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_shmdumpconfig:331
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_shmdumpconfig:344
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_shmdumpconfig:412
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_shmdumpconfig:429
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
sybsystemprocs..sp_shmdumpconfig:460
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpconfig:615
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpconfig:622
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpconfig:684
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpconfig:712
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpconfig:719
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpconfig:824
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpconfig:831
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpconfig:904
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpconfig:1084
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpconfig:1091
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_shmdumpconfig_config:130
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
sybsystemprocs..sp_shmdumpconfig_config:137
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, object_info1}
sybsystemprocs..sp_shmdumpdisp:141
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpdisp:153
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_shmdumpdisp:614
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_shmdumpdisp:623
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_shmdumpdisp:712
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_shmdumpdisp:740
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_shmdumpdisp:762
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpdisp:778
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpdisp:797
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_shmdumpdrop:123
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_shmdumpdrop:135
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, attribute, class}
sybsystemprocs..sp_shmdumpsize:45
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, attribute, class}
sybsystemprocs..sp_shmdumpsize:52
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_showcontrolinfo:92
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute, object_cinfo}
sybsystemprocs..sp_showexeclass:82
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_showexeclass:159
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_showexeclass:223
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {number, id}
sybsystemprocs..sp_showtext:231
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_showtext_output:367
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_spaceusage:164
JOIN Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
Uncovered: [uid]
sybsystemprocs..sp_spaceusage_object_init:263
SARG Candidate index: #indexData.uind unique
(id, indid, ptnid, indexlevel)
Intersection: {ptnid, id, indid}
sybsystemprocs..sp_spaceusage_object_populate:526
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_spaceusage_tranlog_init:77
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_spaceused:154
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_spaceused:158
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_spaceused:180
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_spaceused:204
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_spaceused:207
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_spaceused:255
JOIN Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
Uncovered: [indid]
sybsystemprocs..sp_spaceused:274
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
Uncovered: [attribute, object, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_spaceused:277
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
Uncovered: [object, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_spaceused:278
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_spaceused:395
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_spaceused:448
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
Uncovered: [attribute, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_spaceused:542
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, attribute}
Uncovered: [object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_spaceused:543
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {id}
sybsystemprocs..sp_spaceused:548
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_special_columns:96
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_special_columns:113
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_special_columns:148
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_special_columns:203
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_special_columns:204
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_sproc_columns:38
JOIN Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {number}
Uncovered: [type]
sybsystemprocs..sp_sproc_columns:223
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_sproc_columns:224
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_sproc_columns:289
JOIN Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {number}
Uncovered: [type]
sybsystemprocs..sp_sproc_columns:397
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_sproc_columns:398
JOIN Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {number}
Uncovered: [type]
sybsystemprocs..sp_sproc_columns:513
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_sproc_columns:514
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_sproc_columns:586
JOIN Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {number}
Uncovered: [type]
sybsystemprocs..sp_sproc_columns:697
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_sproc_columns:698
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_ssladmin:67
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object}
sybsystemprocs..sp_ssladmin:92
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_ssladmin:103
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_start_rep_agent:59
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_statistics:155
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_stop_rep_agent:41
SARG Candidate index: #temp_sysmon_baseline.tsbi clustered
(group_name, field_id)
Intersection: {group_name}
sybsystemprocs..sp_sysmon:499
SARG Candidate index: #tempmonitors.tmci clustered
(group_name, field_id)
Intersection: {group_name}
sybsystemprocs..sp_sysmon:528
SARG Candidate index: #tempmonitors.tmci clustered
(group_name, field_id)
Intersection: {group_name}
sybsystemprocs..sp_sysmon:598
SARG Candidate index: #tempmonitors.tmci clustered
(group_name, field_id)
Intersection: {group_name}
sybsystemprocs..sp_sysmon:692
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon:926
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon_collect:176
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon_collect:319
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon_collect:370
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon_collect_mda:79
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon_collect_mda:104
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon_collect_mda:111
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon_collect_mda:118
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_tab_suspectptn:121
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
sybsystemprocs..sp_unbindcache_all:82
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindefault:102
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {id, sequence}
sybsystemprocs..sp_unbindefault:158
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_unbindefault:162
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindefault:190
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..sp_unbindexeclass:206
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..sp_unbindexeclass:216
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_unbindexeclass:257
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_unbindexeclass:267
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_unbindexeclass:306
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..sp_unbindexeclass:314
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_unbindexeclass:340
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_unbindexeclass:346
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_unbindexeclass:353
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1, object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_unbindexeclass:363
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_unbindexeclass:403
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:141
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:181
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:197
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:217
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {id, sequence}
sybsystemprocs..sp_unbindrule:244
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:246
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {id, sequence}
sybsystemprocs..sp_unbindrule:268
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:270
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:297
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:319
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:334
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:345
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:357
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:377
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_unbindrule:391
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
sybsystemprocs..sp_validateconfigname:66
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
sybsystemprocs..sp_validateconfigname:73
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_version:104
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_version:186
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_version:243
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_version:255
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {uid, id, gid}
Uncovered: [hashkey, sequence]
sybsystemprocs..sysquerymetrics:1
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..udf_inactivity_check:38
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_type, attribute}
sybsystemprocs..udf_inactivity_check:55
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, object_cinfo, attribute, class}
sybsystemprocs..udf_inactivity_check:61