QPRI 3 Join or Sarg with Rooted Partial Index Use


SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
master..sp_autoformat:363
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
master..sp_aux_checkroleperm:55
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
master..sp_configure:339
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
master..sp_configure:353
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
master..sp_configure:385
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
master..sp_configure:405
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
master..sp_configure:489
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
master..sp_configure:1129
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}
master..sp_configure:1709
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
master..sp_dboption:165
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
master..sp_dboption:322
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
master..sp_dboption:639
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
master..sp_dboption:661
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
master..sp_dboption:677
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
master..sp_dboption:738
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
master..sp_dboption:832
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
master..sp_dboption:911
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
master..sp_dboption:916
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object}
master..sp_dboption:1314
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
master..sp_dboption_flmode: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}
master..sp_dboption_flmode:186
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class}
master..sp_dboption_flmode:228
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
master..sp_dboption_flmode:244
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, class, attribute}
master..sp_dboption_flmode: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_cinfo, attribute, class}
master..sp_dropdevice:150
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}
master..sp_dropdevice:162
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
master..sp_getmessage:39
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
master..sp_getmessage:60
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
master..sp_getmessage:66
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
master..sp_getmessage:96
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
master..sp_getmessage:102
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
master..sp_getmessage:127
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
master..sp_instmsg:10
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
master..sp_instmsg:16
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {uid, id, gid}
Uncovered: [hashkey, sequence]
master..sysquerymetrics:1
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {uid, id, gid}
Uncovered: [hashkey, sequence]
sybsystemdb..sysquerymetrics:1
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, object_type, attribute}
sybsystemprocs..sp_add_qpgroup:153
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_add_resource_limit:632
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: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_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_addengine:188
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: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_info3, object_cinfo, attribute, class}
sybsystemprocs..sp_addengine:226
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:233
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:171
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: {object_type, object_cinfo, attribute, class}
sybsystemprocs..sp_addexeclass:225
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:246
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:284
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addexternlogin:180
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addexternlogin:200
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:405
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:524
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addgroup:164
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addlanguage:133
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addlanguage:200
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addlogin:246
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addlogin:265
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:341
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:627
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_addmessage:74
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addobjectdef:183
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:211
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addremotelogin:286
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_addsegment:103
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_addsegment:107
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addsegment:136
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addsegment:215
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addsegment:253
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addsegment:266
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addsegment:363
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addserver:205
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addserver:279
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:344
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:376
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:413
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:424
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:636
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addthreshold:166
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_addthreshold:289
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:46
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_addumpdevice:57
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_adduser:197
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_altermessage:84
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_altermessage:136
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_altermessage:153
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_altermessage:170
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_autoformat:363
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_aux_checkroleperm:55
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, predid)
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:357
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:442
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:452
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:212
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:231
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:330
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:338
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:362
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:389
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:397
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:421
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:449
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:455
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:475
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:504
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:513
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:536
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:566
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:573
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:596
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:331
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1423
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1519
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1587
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1661
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1744
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1782
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent, name}
sybsystemprocs..sp_cacheconfig:1791
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, uid, action, grantor, id}
sybsystemprocs..sp_changegroup:272
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, uid, action, grantor, id}
sybsystemprocs..sp_changegroup:288
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {action, protecttype, id, uid, grantor}
sybsystemprocs..sp_changegroup:374
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {action, protecttype, id, uid, grantor}
sybsystemprocs..sp_changegroup:382
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_changegroup:415
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, uid, action, grantor, id}
sybsystemprocs..sp_changegroup:419
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, uid, action, grantor, id}
sybsystemprocs..sp_changegroup:427
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, uid, action, grantor, id}
sybsystemprocs..sp_changegroup:436
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, uid, action, grantor, id}
sybsystemprocs..sp_changegroup:444
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, uid, action, grantor, id}
sybsystemprocs..sp_changegroup:463
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, uid, action, grantor, id}
sybsystemprocs..sp_changegroup:470
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, uid, action, grantor, id}
sybsystemprocs..sp_changegroup:494
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, uid, action, grantor, id}
sybsystemprocs..sp_changegroup:503
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:50
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_checkreswords:74
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_checkreswords:94
JOIN Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
Uncovered: [uid]
sybsystemprocs..sp_checkreswords:163
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_checkreswords:417
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_checkreswords:434
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_chgattribute:405
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_chgattribute:411
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_chgattribute:488
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_chgattribute:494
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_chgattribute:694
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_chgattribute:718
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_chgattribute:820
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {id, indid}
sybsystemprocs..sp_chgattribute:893
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_chgattribute:971
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_chgattribute:977
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_chgattribute:1064
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_chgattribute:1071
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_chgattribute:1140
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:160
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:180
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:145
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: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class, object_cinfo}
sybsystemprocs..sp_config_dump:156
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_config_dump:166
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_config_dump:178
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_config_dump:242
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_config_dump:330
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_config_dump:335
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_config_dump:363
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_config_dump:368
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_config_dump:385
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_config_dump:390
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_config_rep_agent:159
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_config_rep_agent:703
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:949
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_config_rep_agent:1105
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_config_rep_agent:1173
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:1193
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:1214
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:1382
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:1405
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
sybsystemprocs..sp_configure:339
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
sybsystemprocs..sp_configure:353
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
sybsystemprocs..sp_configure:385
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name, parent}
sybsystemprocs..sp_configure:405
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_configure:489
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_configure:1129
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:1709
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {uid, hashkey, gid}
sybsystemprocs..sp_copy_qplan:120
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_dboption:165
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:322
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:639
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:661
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:677
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:738
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_dboption:832
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_dboption:911
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_dboption:916
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:1314
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: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_dboption_flmode:186
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:228
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:244
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:278
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: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_dbrecovery_order:260
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: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, attribute, class}
sybsystemprocs..sp_dbrecovery_order:279
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:297
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: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, attribute, class}
sybsystemprocs..sp_dbrecovery_order:338
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:360
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:366
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:380
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:386
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:403
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:443
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:479
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:489
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:507
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:517
SARG Candidate index: sysusages.ncsysusages unique
(vdevno, vstart)
Intersection: {vdevno}
sybsystemprocs..sp_ddlgen_database:412
SARG Candidate index: syscharsets.csyscharsets unique clustered
(id, csid)
Intersection: {id}
sybsystemprocs..sp_default_charset:19
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_depends:85
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_depends:124
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {id}
sybsystemprocs..sp_depends:146
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_depends:158
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_depends:164
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {id}
sybsystemprocs..sp_depends:175
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {id}
sybsystemprocs..sp_depends:184
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_depends:210
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_depends:213
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_depends:216
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {id}
sybsystemprocs..sp_depends:218
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_depends:363
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:503
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {id}
sybsystemprocs..sp_depends_cols:605
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:156
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: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, attribute, class}
sybsystemprocs..sp_displaylevel:209
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:356
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:361
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displaylogin:366
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:387
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:392
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displaylogin:397
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:401
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:406
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displaylogin:411
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:489
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: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_displayroles:320
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displayroles:327
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:368
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displayroles:376
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:390
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_displayroles:398
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:581
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:633
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:648
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_downgrade:396
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_downgrade:1226
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_downgrade_dump_config:19
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_downgrade_esd:260
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_downgrade_esd:610
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_downgrade_esd:804
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:154
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:150
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:162
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:146
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:221
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: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_cinfo, attribute, class}
sybsystemprocs..sp_dropengine:297
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:336
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:356
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:72
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:130
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_dropextendedproc:79
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: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, attribute, class}
sybsystemprocs..sp_droplockpromote:198
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: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_droplockpromote_ptn:217
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_ptn: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_cinfo, attribute, class}
sybsystemprocs..sp_dropobjectdef:185
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:212
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_dropsegment:155
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_dropsegment:159
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:316
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:333
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:352
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_dropsegment:378
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:403
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:421
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_dropsegment:430
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:437
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:504
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:514
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dropsegment:523
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:253
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:358
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:403
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:480
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:257
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid, id, protecttype}
sybsystemprocs..sp_dropuser:458
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:478
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_drv_bcpmetadata:194
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_drv_bcpmetadata:264
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_drv_bcpmetadata:325
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_drv_column_default:32
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_drv_column_default:41
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_drv_column_default:49
SARG Candidate index: syscharsets.csyscharsets unique clustered
(id, csid)
Intersection: {id}
sybsystemprocs..sp_drv_getsortorder:7
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_drv_getsortorder:7
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_dump_history:160
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_dump_info:73
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:269
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:462
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_encryption:810
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:851
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:878
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:1450
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:1461
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:1471
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:1482
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:1501
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:1511
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:1531
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:1552
JOIN Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {id}
Uncovered: [uid]
sybsystemprocs..sp_encryption:2267
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_encryption:2269
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_encryption:2383
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:3106
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:3127
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:3132
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:3149
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:3177
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:3192
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:3207
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:100
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_extendsegment:104
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:152
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:171
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:226
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:362
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:382
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_extendsegment:409
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:87
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:96
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_fixindex:260
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_fixindex:374
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_fixindex:417
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_forceonline_db:47
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:133
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:151
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:168
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_forceonline_object:65
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:149
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:176
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:194
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:244
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: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_object:288
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:323
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:335
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_forceonline_page:58
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: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_page:165
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:181
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:229
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:240
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:269
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: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, attribute, class}
sybsystemprocs..sp_forceonline_page:312
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: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_hadr_admin:219
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_hadr_admin:232
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {class}
sybsystemprocs..sp_hadr_admin:571
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_hadr_update:33
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_hadr_update:79
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_hadr_update:83
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_hadr_update:152
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_help:104
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_help:153
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_help:350
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_help:426
JOIN Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
Uncovered: [uid]
sybsystemprocs..sp_help:432
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_help:454
JOIN Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
Uncovered: [uid]
sybsystemprocs..sp_help:460
JOIN Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
Uncovered: [uid]
sybsystemprocs..sp_help:470
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_help:509
JOIN Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
Uncovered: [uid]
sybsystemprocs..sp_help:515
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_help:589
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
Uncovered: [number]
sybsystemprocs..sp_help:684
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_help:703
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_help:821
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:873
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:939
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:940
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_help:957
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:1083
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:1084
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_help:1296
JOIN Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
Uncovered: [number, colid2, colid, texttype]
sybsystemprocs..sp_help:1445
JOIN Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
Uncovered: [number, colid2, colid, texttype]
sybsystemprocs..sp_help:1457
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:94
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_help_rep_agent:74
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:530
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_helpartition:581
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helpartition:619
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_helpartition:623
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helpartition:635
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {partitionid, id}
sybsystemprocs..sp_helpartition:663
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_helpartition:729
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
JOIN Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
Uncovered: [number, colid2, colid, texttype]
sybsystemprocs..sp_helpcomputedcolumn:229
JOIN Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
Uncovered: [number, colid2, colid, texttype]
sybsystemprocs..sp_helpcomputedcolumn:241
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_helpconfig:142
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpconfig:382
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpconfig_est_compinfo_poolsize:66
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpconfig_est_compinfo_poolsize:70
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpconfig_est_compinfo_poolsize:74
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpconfig_est_compinfo_poolsize:78
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpconfig_est_compinfo_poolsize:82
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_helpconfig_est_compinfo_poolsize:86
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:78
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpdb:84
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:272
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:276
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdb:313
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdb:358
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdb:403
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel, langid]
sybsystemprocs..sp_helpdb:436
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel, langid]
sybsystemprocs..sp_helpdb:444
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdb:512
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdb:562
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:616
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:632
JOIN Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
Uncovered: [lstart]
sybsystemprocs..sp_helpdb:704
SARG Candidate index: sysusages.ncsysusages unique
(vdevno, vstart)
Intersection: {vdevno}
sybsystemprocs..sp_helpdb:705
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:774
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:775
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpdb:816
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_helpdb:829
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpdb:912
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_helpdb:931
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_helpdb:945
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:383
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_helpindex:428
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:359
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {id}
sybsystemprocs..sp_helprotect:651
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {id}
sybsystemprocs..sp_helprotect:665
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid, id}
sybsystemprocs..sp_helprotect:677
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_helpsegment:91
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_helpsegment:104
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_helpsegment:131
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_helpsegment:144
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_helpsegment:187
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:319
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {number, id}
sybsystemprocs..sp_helptext:336
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helptext:350
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helptext:376
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helptext:386
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_helptext:398
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {number, id}
sybsystemprocs..sp_helptext:407
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_helpthreshold:30
SARG Candidate index: sysconstraints.csysconstraints clustered
(tableid, colid)
Intersection: {tableid}
sybsystemprocs..sp_helptrigger:197
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, predid)
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
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_ijdbc_getbestrowidentifier:127
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_ijdbc_getbestrowidentifier:179
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {id}
Uncovered: [grantor, uid, predid]
sybsystemprocs..sp_ijdbc_getcolumnprivileges:181
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:189
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {id}
Uncovered: [grantor, uid, predid]
sybsystemprocs..sp_ijdbc_getcolumnprivileges:216
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:223
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {id}
Uncovered: [grantor, uid, predid]
sybsystemprocs..sp_ijdbc_getcolumnprivileges:249
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:256
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {id}
Uncovered: [grantor, uid, predid]
sybsystemprocs..sp_ijdbc_getcolumnprivileges:282
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:289
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {id}
Uncovered: [grantor, uid, predid]
sybsystemprocs..sp_ijdbc_getcolumnprivileges:316
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:324
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {id}
Uncovered: [grantor, uid, predid]
sybsystemprocs..sp_ijdbc_getcolumnprivileges:355
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
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_ijdbc_getversioncolumns:123
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:120
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, predid)
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:334
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_jdbc_getbestrowidentifier:35
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_jdbc_getbestrowidentifier:137
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_jdbc_getbestrowidentifier:184
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_jdbc_getbestrowidentifier:185
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_jdbc_getindexinfo:167
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_jdbc_getversioncolumns:137
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:172
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:176
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:179
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:182
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:185
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:205
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:209
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:213
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:217
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:221
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:225
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:229
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:233
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:237
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_ldapadmin:361
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_ldapadmin:364
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:411
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:415
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: {object, object_cinfo, attribute, class}
sybsystemprocs..sp_locklogin: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_locklogin:215
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_locklogin:220
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:791
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_logdevice:176
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_logdevice:193
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_logdevice:218
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_logdevice:226
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:101
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:160
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:202
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:210
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:303
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:334
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:349
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_makesuspect_obj:81
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:155
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:171
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:271
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:283
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:293
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:314
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:342
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:366
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:371
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:458
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:488
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:507
SARG Candidate index: spt_mda.spt_mda_ind unique
(mdinfo, mdaver_end, srvver_end)
Intersection: {mdinfo}
sybsystemprocs..sp_mda: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_memlog:175
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_merge_dup_inline_default:484
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {id}
sybsystemprocs..sp_merge_dup_inline_default:540
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {id}
sybsystemprocs..sp_merge_dup_inline_default:549
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:476
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:499
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:768
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:793
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:833
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:893
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_modifystats:186
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {action, id}
sybsystemprocs..sp_modifystats:277
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_modifystats:387
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_modifystats:396
SARG Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray, id, formatid}
sybsystemprocs..sp_modifystats:403
SARG Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {formatid, id}
sybsystemprocs..sp_modifystats:449
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_modifystats:468
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_modifystats:477
SARG Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray, id, formatid}
sybsystemprocs..sp_modifystats:490
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_modifystats:629
SARG Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray, id, formatid}
sybsystemprocs..sp_modifystats:681
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_modifystats:710
JOIN Candidate index: #old_new_values.densities_CI unique clustered
(indid, partitionid, colidarray)
Intersection: {colidarray, indid}
Uncovered: [partitionid]
sybsystemprocs..sp_modifystats:780
JOIN Candidate index: #old_new_values.densities_CI unique clustered
(indid, partitionid, colidarray)
Intersection: {colidarray, indid}
Uncovered: [partitionid]
sybsystemprocs..sp_modifystats:790
JOIN Candidate index: #old_new_values.densities_CI unique clustered
(indid, partitionid, colidarray)
Intersection: {colidarray, indid}
Uncovered: [partitionid]
sybsystemprocs..sp_modifystats:805
JOIN Candidate index: #old_new_values.densities_CI unique clustered
(indid, partitionid, colidarray)
Intersection: {colidarray, indid}
Uncovered: [partitionid]
sybsystemprocs..sp_modifystats:815
JOIN Candidate index: #old_new_values.densities_CI unique clustered
(indid, partitionid, colidarray)
Intersection: {colidarray, indid}
Uncovered: [partitionid]
sybsystemprocs..sp_modifystats:830
JOIN Candidate index: #old_new_values.densities_CI unique clustered
(indid, partitionid, colidarray)
Intersection: {colidarray, indid}
Uncovered: [partitionid]
sybsystemprocs..sp_modifystats:840
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_modifythreshold:166
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_modifythreshold:254
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:154
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: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_odbc_fkeys:380
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_odbc_getindexinfo:144
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_odbc_getversioncolumns:102
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_odbc_getversioncolumns:120
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_odbc_getversioncolumns:156
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_odbc_getversioncolumns:213
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_odbc_getversioncolumns:214
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_oledb_fkeys:371
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:81
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_opt_querystats_main:482
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_opt_querystats_main:496
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_cinfo}
sybsystemprocs..sp_optbitmap:28
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_cinfo}
sybsystemprocs..sp_optbitmap:45
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_optgoal: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, object_cinfo}
sybsystemprocs..sp_optgoal:105
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_cinfo}
sybsystemprocs..sp_optgoal:148
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_cinfo}
sybsystemprocs..sp_optgoal:170
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_cinfo}
sybsystemprocs..sp_optgoal:181
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:268
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_passwordpolicy:328
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_passwordpolicy:344
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_placeobject:201
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
sybsystemprocs..sp_placeobject:285
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {id, indid}
sybsystemprocs..sp_placeobject:312
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {id, indid}
sybsystemprocs..sp_placeobject:322
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_placeobject:402
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_placeobject:433
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_placeobject:465
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid, id}
sybsystemprocs..sp_placeobject:496
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: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_plan_dbccdb:373
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_plan_dbccdb:401
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_plan_dbccdb:532
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
Uncovered: [number]
sybsystemprocs..sp_post_xpload:176
JOIN Candidate index: syspartitionkeys.csyspartitionkeys unique clustered
(id, indid, colid)
Intersection: {colid, id}
Uncovered: [indid]
sybsystemprocs..sp_post_xpload:176
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
Uncovered: [number]
sybsystemprocs..sp_post_xpload:195
JOIN Candidate index: syspartitionkeys.csyspartitionkeys unique clustered
(id, indid, colid)
Intersection: {colid, id}
Uncovered: [indid]
sybsystemprocs..sp_post_xpload:195
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:143
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_remoteoption:176
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_remoteoption:253
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_remoteoption:309
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_remoteoption:347
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_rename:95
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_rename:98
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_rename:366
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_rename:417
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_rename:436
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_rename:539
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid, id}
sybsystemprocs..sp_rename:553
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_rename:941
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_rename:959
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:970
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:981
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:1114
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:156
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_renamedb:137
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_repdbsync:72
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_repdbsync:75
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:400
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_replication_path:518
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_replication_path: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, attribute, class}
sybsystemprocs..sp_replication_path:569
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:642
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:747
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:769
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:848
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:879
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:890
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:910
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:923
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:933
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:956
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:961
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:966
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:1001
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:1006
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:1011
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:1032
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_replication_path:1185
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:1417
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:1442
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:1456
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:1460
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:1750
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:1856
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:1939
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_reptostandby:123
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:67
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:102
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:188
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:284
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:93
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:346
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:445
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_setlockpromote_ptn:160
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_ptn:244
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_setlockpromote_ptn:355
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_ptn:366
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:189
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:225
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:234
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:261
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:268
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setrepcol:130
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:218
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:234
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:254
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:308
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:338
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:463
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:503
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:539
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepcol:578
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setrepdbmode:144
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setrepdefmode:157
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setrepdefmode:547
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setreplicate:173
JOIN Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
Uncovered: [dlevel]
sybsystemprocs..sp_setreplicate:198
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setreplicate:264
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setreplicate:445
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setreplicate:469
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setreplicate:535
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setrepproc:202
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setrepproc:203
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setrepproc:580
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setreptable:210
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setreptable:656
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setreptable:751
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
sybsystemprocs..sp_setreptable:764
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:163
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: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, attribute, class}
sybsystemprocs..sp_setsuspect_granularity:207
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:217
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:233
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:247
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:279
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_setsuspect_threshold: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_setsuspect_threshold:110
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:213
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:238
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: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_setsuspect_threshold:268
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_setup_table_transfer:90
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_shmdumpconfig:305
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:312
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:362
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:375
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_shmdumpconfig:443
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error}
sybsystemprocs..sp_shmdumpconfig:461
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:492
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:647
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:654
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:716
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:744
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:751
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:856
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:863
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:936
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:1136
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:1143
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: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_shmdumpconfig_config:163
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:161
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_shmdumpdisp:250
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_shmdumpdisp:672
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_shmdumpdisp:681
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_shmdumpdisp:787
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_shmdumpdisp:815
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {name}
sybsystemprocs..sp_shmdumpdisp:837
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: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_shmdumpdisp:872
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: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, attribute, class}
sybsystemprocs..sp_shmdumpdrop:159
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:275
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
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {id}
Uncovered: [number, colid]
sybsystemprocs..sp_spaceusage_object_populate:163
SARG Candidate index: #indexData.uind unique
(id, indid, ptnid, indexlevel)
Intersection: {ptnid, id, indid}
sybsystemprocs..sp_spaceusage_object_populate:548
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:241
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:261
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_spaceused:284
JOIN Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {id}
Uncovered: [indid]
sybsystemprocs..sp_spaceused:456
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:459
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:460
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:723
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:724
SARG Candidate index: systabstats.csystabstats unique clustered
(id, indid, partitionid)
Intersection: {id}
sybsystemprocs..sp_spaceused:730
SARG Candidate index: sysusages.csysusages unique clustered
(dbid, lstart)
Intersection: {dbid}
sybsystemprocs..sp_spaceused_syslogs:25
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:88
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:113
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:124
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
sybsystemprocs..sp_start_rep_agent:66
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:50
SARG Candidate index: #temp_sysmon_baseline.tsbi clustered
(group_name, field_id)
Intersection: {group_name}
sybsystemprocs..sp_sysmon:546
SARG Candidate index: #tempmonitors.tmci clustered
(group_name, field_id)
Intersection: {group_name}
sybsystemprocs..sp_sysmon:575
SARG Candidate index: #tempmonitors.tmci clustered
(group_name, field_id)
Intersection: {group_name}
sybsystemprocs..sp_sysmon:614
SARG Candidate index: #tempmonitors.tmci clustered
(group_name, field_id)
Intersection: {group_name}
sybsystemprocs..sp_sysmon:748
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon:994
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon_collect:242
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon_collect:404
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {name}
sybsystemprocs..sp_sysmon_collect:449
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:100
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:238
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:248
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:289
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:299
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:338
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: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:372
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:378
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:385
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:395
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:435
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:108
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: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_cinfo, attribute, class}
sybsystemprocs..sp_version:263
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:275
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {uid, id, gid}
Uncovered: [hashkey, sequence]
sybsystemprocs..sysquerymetrics:1
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {uid, id, gid}
Uncovered: [hashkey, sequence]
tempdb..sysquerymetrics:1