QPUI 4 Join or Sarg with Un-Rooted Partial Index Use


SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type}
sybsystemprocs..sp_activeroles: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}
sybsystemprocs..sp_addlogin:389
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addlogin:491
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addlogin:510
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addobjectdef:66
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_addremotelogin:214
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_addremotelogin:285
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_addremotelogin:310
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_addremotelogin:354
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addserver:209
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addserver:529
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addserver:531
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addserver:540
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addserver:543
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addtabledef:28
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addumpdevice:187
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_aux_encr_verify_downgrade:95
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_aux_encr_verify_downgrade:130
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_aux_encr_verify_downgrade:173
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_aux_encr_verify_downgrade:489
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_aux_encr_verify_downgrade:532
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_aux_encr_verify_downgrade:541
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_backup_metrics:44
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_backup_metrics:56
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_bindcache:298
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_bindcache:375
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_bindmsg:203
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_changedbowner:120
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_changedbowner:307
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
sybsystemprocs..sp_changegroup:182
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_checknames:206
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_checknames:221
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_checknames:287
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:100
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:110
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_checkreswords:112
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_checkreswords:113
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:120
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:128
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:142
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:151
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_checkreswords:153
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:160
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:167
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:193
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:208
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_checkreswords:210
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_checkreswords:211
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:224
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:238
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:273
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:278
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:286
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:291
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:307
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:311
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:319
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:323
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:331
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:335
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:343
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:347
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:355
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:359
JOIN Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
Uncovered: [remoteserverid]
sybsystemprocs..sp_checkreswords:367
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:367
JOIN Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
Uncovered: [remoteserverid]
sybsystemprocs..sp_checkreswords:373
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:373
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:381
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:385
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:393
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:397
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_chgattribute:113
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_chgattribute:151
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_chgattribute:163
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_chgattribute:331
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type}
sybsystemprocs..sp_cmp_all_qplans:280
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type}
sybsystemprocs..sp_cmp_all_qplans:335
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_cmp_qplans:65
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_cmp_qplans:71
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_cmp_qplans:98
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_cmp_qplans:104
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {sequence}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_cmp_qplans:115
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_cmp_qplans:131
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_cmp_qplans:137
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {sequence}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_cmp_qplans:148
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_config_rep_agent:125
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:219
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:836
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:858
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:863
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:872
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:1046
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_configure:1701
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_configure:1768
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object}
Uncovered: [object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_configure:1812
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type}
sybsystemprocs..sp_copy_all_qplans:63
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_copy_qplan:74
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_copy_qplan:135
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_copy_qplan:144
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:179
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:184
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:189
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:194
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:397
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:438
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:465
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:482
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:494
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:520
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:540
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:554
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:597
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:609
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:631
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:686
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:699
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dbrecovery_order:124
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_ddlgen_database:268
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_ddlgen_permissions:46
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_defaultloc:60
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_defaultloc:94
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_defaultloc:150
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {depid}
sybsystemprocs..sp_depends:206
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {depid}
sybsystemprocs..sp_depends:227
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_deviceattr:167
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type}
sybsystemprocs..sp_displaylogin:304
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_displaylogin:372
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_displaylogin:388
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_displaylogin:394
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type}
sybsystemprocs..sp_displayroles:119
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type}
sybsystemprocs..sp_displayroles:123
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type}
sybsystemprocs..sp_displayroles:293
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_downgrade:813
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_downgrade:819
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_downgrade:854
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_downgrade:894
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_downgrade:897
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type}
sybsystemprocs..sp_drop_all_qplans:65
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type}
sybsystemprocs..sp_drop_all_qplans:70
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_drop_metrics:41
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_drop_metrics:62
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_drop_metrics:73
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_drop_qpgroup:102
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_drop_qplan:37
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_drop_query_tuning:48
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, sequence]
sybsystemprocs..sp_drop_query_tuning:69
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_drop_query_tuning:69
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_drop_query_tuning:69
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_drop_query_tuning:80
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type}
sybsystemprocs..sp_drop_query_tuning:81
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_dropgroup:147
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
sybsystemprocs..sp_dropgroup:202
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {langid}
sybsystemprocs..sp_droplanguage:127
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {langid}
sybsystemprocs..sp_droplanguage: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}
sybsystemprocs..sp_droplogin:481
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_type, object_cinfo}
sybsystemprocs..sp_droplogin:486
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_dropremotelogin:167
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dropsegment:142
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dropsegment:237
SARG Candidate index: syscoordinations.csyscoordinations unique clustered
(xactkey, participant, owner)
Intersection: {owner}
sybsystemprocs..sp_dropserver:241
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dropuser:185
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:212
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {grantor}
sybsystemprocs..sp_dropuser:218
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:220
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:240
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dropuser:333
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, uid}
sybsystemprocs..sp_dropuser:347
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
sybsystemprocs..sp_dropuser:420
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object}
sybsystemprocs..sp_dropuser:446
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:454
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:457
SARG Candidate index: syscoordinations.csyscoordinations unique clustered
(xactkey, participant, owner)
Intersection: {owner}
sybsystemprocs..sp_dtx_purge_completedxacts:43
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid}
sybsystemprocs..sp_encryption:767
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_encryption:768
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1}
Uncovered: [class, attribute, object_type, object, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_encryption:1409
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1}
Uncovered: [object_type, object, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_encryption:1409
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1}
Uncovered: [class, attribute, object_type, object, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_encryption:1410
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1}
Uncovered: [class, object_type, object, object_info3, object_cinfo]
sybsystemprocs..sp_encryption:1410
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {colid}
sybsystemprocs..sp_encryption:1523
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_encryption:1918
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid, type}
sybsystemprocs..sp_encryption:1989
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_encryption:2357
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_encryption:2358
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_encryption:2418
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_encryption:2419
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid, type}
sybsystemprocs..sp_encryption:2493
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid, type}
sybsystemprocs..sp_encryption:2568
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid, type}
sybsystemprocs..sp_encryption:2631
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid, type}
sybsystemprocs..sp_encryption:2706
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1}
Uncovered: [class, attribute, object_type, object, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_encryption:2834
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1}
Uncovered: [object_type, object, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_encryption:2834
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1}
Uncovered: [class, attribute, object_type, object, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_encryption:2835
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1}
Uncovered: [class, object_type, object, object_info3, object_cinfo]
sybsystemprocs..sp_encryption:2835
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_estspace:365
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_extendsegment:277
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_extendsegment:321
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_filter_metrics:46
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {sequence, type}
Uncovered: [uid, gid, hashkey, id]
sybsystemprocs..sp_find_qplan:75
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_fixindex:208
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_fkeys:175
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_fkeys:241
SARG Candidate index: sysreferences.csysreferences clustered
(tableid, frgndbname)
Intersection: {frgndbname}
sybsystemprocs..sp_fkeys:288
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info2, object_info1}
Uncovered: [object_type, object, object_info3, object_cinfo]
sybsystemprocs..sp_help:466
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object}
Uncovered: [object_type, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_help:721
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_info1}
Uncovered: [object_type, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_help:722
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object}
sybsystemprocs..sp_help:842
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object}
Uncovered: [object_type, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_help:865
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_info1}
Uncovered: [object_type, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_help:866
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:101
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:111
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type, sequence}
sybsystemprocs..sp_help_qpgroup:145
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type, sequence}
sybsystemprocs..sp_help_qpgroup:153
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:185
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_help_qpgroup:211
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_help_qpgroup:211
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_help_qpgroup:216
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_help_qpgroup:216
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:221
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_help_qpgroup:233
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_help_qpgroup:233
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:238
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_help_qpgroup:250
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_help_qpgroup:250
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:255
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_help_qpgroup:269
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_help_qpgroup:269
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:274
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_help_qplan:101
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_help_qplan:113
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_help_rep_agent:51
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpartition:88
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpartition:90
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpartition:92
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpartition:94
SARG Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid}
sybsystemprocs..sp_helpartition:108
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_helpartition:115
JOIN Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
Uncovered: [id]
sybsystemprocs..sp_helpartition:322
JOIN Candidate index: syspartitionkeys.csyspartitionkeys unique clustered
(id, indid, colid)
Intersection: {indid}
Uncovered: [colid]
sybsystemprocs..sp_helpartition:322
JOIN Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
Uncovered: [id]
sybsystemprocs..sp_helpartition:342
JOIN Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {indid}
Uncovered: [partitionid]
sybsystemprocs..sp_helpartition:342
JOIN Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {partitionid}
Uncovered: [id, indid]
sybsystemprocs..sp_helpartition:608
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpcache:286
SARG Candidate index: sysreferences.nc2sysreferences
(reftabid, indexid, pmrydbname)
Intersection: {pmrydbname}
sybsystemprocs..sp_helpconstraint:88
SARG Candidate index: sysreferences.csysreferences clustered
(tableid, frgndbname)
Intersection: {frgndbname}
sybsystemprocs..sp_helpconstraint:91
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpdb:112
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpdb:119
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpdb:126
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpdb:133
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpdb:182
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object}
Uncovered: [object_type, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_helpdb:613
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_info1}
Uncovered: [object_type, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_helpdb:614
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpdb:666
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_info1, object_type}
sybsystemprocs..sp_helpindex:321
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpmaplogin:38
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1}
Uncovered: [object_type, object, object_info2, object_info3]
sybsystemprocs..sp_helpmaplogin:64
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpmaplogin:64
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info2}
Uncovered: [object_type, object, object_info1, object_info3, object_cinfo]
sybsystemprocs..sp_helpobjectdef:68
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info2}
Uncovered: [object_type, object, object_info1, object_info3]
sybsystemprocs..sp_helpobjectdef:205
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info2}
Uncovered: [object_type, object, object_info3]
sybsystemprocs..sp_helpobjectdef:231
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_helpremotelogin:80
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_helpremotelogin:102
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_helpremotelogin:152
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_helpremotelogin:171
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type}
sybsystemprocs..sp_helprotect:79
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helprotect:315
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helprotect:318
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helprotect:1066
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helprotect:1068
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helprotect:1104
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helprotect:1106
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helprotect:1154
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helprotect:1156
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpserver:99
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpsort:183
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_ijdbc_fkeys:180
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_ijdbc_fkeys:209
SARG Candidate index: sysreferences.csysreferences clustered
(tableid, frgndbname)
Intersection: {frgndbname}
sybsystemprocs..sp_ijdbc_fkeys:243
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_ijdbc_getbestrowidentifier:113
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:182
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:194
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:217
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:228
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:250
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:261
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:283
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:294
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:317
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:329
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:355
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_ijdbc_getindexinfo:125
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_ijdbc_getindexinfo:204
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {number}
sybsystemprocs..sp_ijdbc_getprocedurecolumns:130
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {number}
sybsystemprocs..sp_ijdbc_getprocedurecolumns:132
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {number}
sybsystemprocs..sp_ijdbc_getprocedurecolumns:177
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:55
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_ijdbc_gettableprivileges:65
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:69
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:78
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_ijdbc_gettableprivileges:88
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:92
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:100
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_ijdbc_gettableprivileges:110
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:114
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:122
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_ijdbc_gettableprivileges:132
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:136
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:145
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_ijdbc_gettableprivileges:156
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:160
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:171
SARG Candidate index: spt_ijdbc_mda.spt_ijdbc_mda_ind unique
(mdinfo, mdaver_end, srvver_end)
Intersection: {srvver_end, mdaver_end}
sybsystemprocs..sp_ijdbc_mda:101
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {sequence}
sybsystemprocs..sp_ijdbc_stored_procedures:99
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_ijdbc_stored_procedures:190
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action}
sybsystemprocs..sp_ijdbc_stored_procedures:212
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_import_qpgroup:127
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_jdbc_fkeys:177
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_jdbc_fkeys:206
SARG Candidate index: sysreferences.csysreferences clustered
(tableid, frgndbname)
Intersection: {frgndbname}
sybsystemprocs..sp_jdbc_fkeys:247
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid}
Uncovered: [id, number]
sybsystemprocs..sp_jdbc_getbestrowidentifier:185
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {number}
sybsystemprocs..sp_jdbc_getfunctioncolumns:95
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {number}
sybsystemprocs..sp_jdbc_getfunctioncolumns:190
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {number}
sybsystemprocs..sp_jdbc_getfunctioncolumns:201
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {number}
sybsystemprocs..sp_jdbc_getfunctioncolumns:216
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {number}
sybsystemprocs..sp_jdbc_getfunctioncolumns:290
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {number}
sybsystemprocs..sp_jdbc_getfunctioncolumns:301
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_jdbc_getindexinfo:227
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {sequence}
sybsystemprocs..sp_jdbc_stored_procedures:118
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_jdbc_stored_procedures:205
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {sequence}
sybsystemprocs..sp_jdbc_stored_procedures:225
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_jdbc_stored_procedures:312
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {sequence}
sybsystemprocs..sp_jdbc_stored_procedures:337
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_jdbc_stored_procedures:354
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_logdevice:91
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_logdevice:116
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_logiosize:252
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_logiosize:261
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_lookup:61
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_maplogin:172
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_maplogin:222
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_maplogin:255
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1}
Uncovered: [object_type, object, object_info2, object_info3]
sybsystemprocs..sp_maplogin:427
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_maplogin:428
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_info1}
Uncovered: [object_type, object, object_info2, object_info3]
sybsystemprocs..sp_maplogin:458
SARG Candidate index: spt_mda.spt_mda_ind unique
(mdinfo, mdaver_end, srvver_end)
Intersection: {srvver_end, mdaver_end}
sybsystemprocs..sp_mda:106
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_merge_dup_inline_default:94
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {type, number, sequence}
sybsystemprocs..sp_merge_dup_inline_default:131
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {texttype, colid, number, colid2}
sybsystemprocs..sp_merge_dup_inline_default:135
SARG Candidate index: #defval_tab.i1 unique
(uid, inline_default)
Intersection: {inline_default}
sybsystemprocs..sp_merge_dup_inline_default:152
SARG Candidate index: #defval_tab.i1 unique
(uid, inline_default)
Intersection: {inline_default}
sybsystemprocs..sp_merge_dup_inline_default:164
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {colid, number, colid2}
sybsystemprocs..sp_merge_dup_inline_default:434
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_merge_dup_inline_default:439
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {type, number, sequence}
sybsystemprocs..sp_merge_dup_inline_default:442
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_modifylogin:763
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_modifylogin:812
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_modifylogin:826
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_modifylogin:840
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [grantor, protecttype]
sybsystemprocs..sp_modifystats:288
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_monitor_list:155
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_monitor_procstack:126
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_multdb_addtogroup:111
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_multdb_addtogroup:116
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_multdb_bind:106
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_multdb_removefromgroup:121
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_multdb_removefromgroup:125
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_multdb_show:77
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_multdb_show:81
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object}
Uncovered: [attribute, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_multdb_show:162
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_multdb_unbindall_db:48
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_multdb_unbindall_db:56
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_odbc_fkeys:178
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_odbc_fkeys:244
SARG Candidate index: sysreferences.csysreferences clustered
(tableid, frgndbname)
Intersection: {frgndbname}
sybsystemprocs..sp_odbc_fkeys:293
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_odbc_getindexinfo:206
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {number}
sybsystemprocs..sp_odbc_getprocedurecolumns:240
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {number}
sybsystemprocs..sp_odbc_getprocedurecolumns:447
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid}
Uncovered: [id, number]
sybsystemprocs..sp_odbc_getversioncolumns:211
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {sequence}
sybsystemprocs..sp_odbc_stored_procedures:98
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_odbc_stored_procedures:193
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action}
sybsystemprocs..sp_odbc_stored_procedures:215
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_odbc_tables:313
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action}
sybsystemprocs..sp_odbc_tables:338
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_oledb_fkeys:183
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_oledb_fkeys:249
SARG Candidate index: sysreferences.csysreferences clustered
(tableid, frgndbname)
Intersection: {frgndbname}
sybsystemprocs..sp_oledb_fkeys:284
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {number}
sybsystemprocs..sp_oledb_getprocedurecolumns:251
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {number}
sybsystemprocs..sp_oledb_getprocedurecolumns:415
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_oledb_primarykey:80
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_oledb_statistics:290
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {sequence}
sybsystemprocs..sp_oledb_stored_procedures:103
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_oledb_stored_procedures:198
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action}
sybsystemprocs..sp_oledb_stored_procedures:220
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_oledb_tables:354
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action}
sybsystemprocs..sp_oledb_tables:379
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_oledb_views:293
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action}
sybsystemprocs..sp_oledb_views:318
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_passwordpolicy:207
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_cinfo}
Uncovered: [class, attribute, object_type, object, object_info1, object_info2, object_info3]
sybsystemprocs..sp_passwordpolicy:302
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_passwordpolicy:305
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_cinfo}
sybsystemprocs..sp_passwordpolicy:306
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_cinfo}
Uncovered: [class, attribute, object_type, object, object_info1, object_info2, object_info3]
sybsystemprocs..sp_passwordpolicy:316
SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_cinfo}
sybsystemprocs..sp_passwordpolicy:317
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_passwordpolicy:318
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_placeobject:156
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_plan_dbccdb:85
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_plan_dbccdb:88
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_plan_dbccdb:91
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_post_xpload:80
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_post_xpload:93
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_post_xpload:126
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_post_xpload:132
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_post_xpload:143
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_post_xpload:151
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_remoteoption:179
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_remoteoption:340
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_remoteoption:365
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_rename:213
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_renamedb:147
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_set_qplan:57
SARG Candidate index: sysquerymetrics.csysqueryplans_sysqueryplans unique clustered
(uid, gid, hashkey, id, sequence)
Intersection: {sequence}
sybsystemprocs..sp_show_metrics:17
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type}
sybsystemprocs..sp_show_query_tuning:48
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type}
sybsystemprocs..sp_show_query_tuning:60
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, sequence]
sybsystemprocs..sp_show_query_tuning:64
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_show_query_tuning:64
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, sequence]
sybsystemprocs..sp_show_query_tuning:69
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_show_query_tuning:69
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, sequence]
sybsystemprocs..sp_show_query_tuning:75
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_show_query_tuning:75
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type}
sybsystemprocs..sp_show_query_tuning:87
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, sequence]
sybsystemprocs..sp_show_query_tuning:91
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_show_query_tuning:91
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, sequence]
sybsystemprocs..sp_show_query_tuning:96
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_show_query_tuning:96
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, sequence]
sybsystemprocs..sp_show_query_tuning:102
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_show_query_tuning:102
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_spaceusage_object_init:295
SARG Candidate index: #indexData.uind unique
(id, indid, ptnid, indexlevel)
Intersection: {indexlevel}
sybsystemprocs..sp_spaceusage_object_populate:393
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object}
Uncovered: [class, attribute, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_spaceused:274
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object}
Uncovered: [object_type, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_spaceused:277
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_info1}
Uncovered: [object_type, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_spaceused:278
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object}
Uncovered: [object_type, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_spaceused:542
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object, object_info1}
Uncovered: [object_type, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_spaceused:543
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid}
Uncovered: [id, number]
sybsystemprocs..sp_special_columns:202
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {number}
sybsystemprocs..sp_sproc_columns:236
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {number}
sybsystemprocs..sp_sproc_columns:412
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {number}
sybsystemprocs..sp_sproc_columns:539
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_statistics:228
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {sequence}
sybsystemprocs..sp_stored_procedures:103
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_stored_procedures:198
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action}
sybsystemprocs..sp_stored_procedures:220
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_sysmon:888
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_sysmon:905
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_sysmon_dcachestats:115
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {uid}
Uncovered: [id, grantor, protecttype]
sybsystemprocs..sp_tables:316
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype)
Intersection: {action}
sybsystemprocs..sp_tables:341
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_unbindmsg:176
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_update_authmech_value:92