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


SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_configure:254
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_configure:936
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_configure:958
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_configure:963
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_configure:972
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_configure:1146
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
master..sp_configure:1887
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
master..sp_configure:1958
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]
master..sp_configure:2002
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:210
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:215
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:220
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:225
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:230
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:500
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:541
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:568
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:587
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:601
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:629
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:651
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:667
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:712
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:726
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:750
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:807
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
master..sp_dboption:822
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
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_activeroles:174
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addexternlogin:480
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:411
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addlogin:513
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addlogin:532
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addobjectdef:69
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_addremotelogin:232
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_addremotelogin:303
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_addremotelogin:328
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_addremotelogin:372
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addremotelogin:426
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addserver:240
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addserver:560
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addserver:562
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addserver:571
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addserver:574
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_addserver:719
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:216
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:96
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_backup_metrics:108
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_bindcache:320
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_bindcache:397
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:138
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_changedbowner:325
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
sybsystemprocs..sp_changegroup:230
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid, predid, action}
sybsystemprocs..sp_changegroup:336
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid, predid, action}
sybsystemprocs..sp_changegroup:546
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:103
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:113
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_checkreswords:115
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_checkreswords:116
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:123
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:131
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:145
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:154
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_checkreswords:156
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:163
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:170
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:196
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:211
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_checkreswords:213
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_checkreswords:214
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:227
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:241
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:276
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:281
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:289
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:294
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:310
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:314
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:322
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:326
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:334
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:338
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:346
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:350
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:358
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:362
JOIN Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
Uncovered: [remoteserverid]
sybsystemprocs..sp_checkreswords:370
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:370
JOIN Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
Uncovered: [remoteserverid]
sybsystemprocs..sp_checkreswords:376
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:376
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:384
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:388
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:396
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_checkreswords:400
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_chgattribute:116
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_chgattribute:155
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_chgattribute:167
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_chgattribute:338
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type}
sybsystemprocs..sp_cmp_all_qplans:315
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type}
sybsystemprocs..sp_cmp_all_qplans:370
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_cmp_qplans:102
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_cmp_qplans:108
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_cmp_qplans:135
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_cmp_qplans:141
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {sequence}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_cmp_qplans:152
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_cmp_qplans:168
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_cmp_qplans:174
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {sequence}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_cmp_qplans:185
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute}
Uncovered: [object_type, object, object_info1, object_info2, object_info3]
sybsystemprocs..sp_config_dump:261
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_config_rep_agent:170
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:254
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:936
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:958
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:963
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:972
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_configure:1146
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_configure:1887
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_configure:1958
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:2002
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type}
sybsystemprocs..sp_copy_all_qplans:92
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_copy_qplan:104
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_copy_qplan:165
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_copy_qplan:174
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:210
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:215
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:220
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:225
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:230
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:500
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:541
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:568
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:587
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:601
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:629
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:651
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:667
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:712
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:726
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:750
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:807
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dboption:822
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dbrecovery_order:131
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_ddlgen_database:285
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_ddlgen_permissions:95
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:151
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {depid}
sybsystemprocs..sp_depends:231
SARG Candidate index: sysdepends.csysdepends unique clustered
(id, number, depid, depnumber)
Intersection: {depid}
sybsystemprocs..sp_depends:256
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_deviceattr:208
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:352
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_displaylogin:420
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_displaylogin:436
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_displaylogin:442
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:129
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:133
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:303
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_displayroles:717
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_displayroles:734
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_downgrade:963
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_downgrade:969
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_downgrade:1004
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_downgrade:1051
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_downgrade:1055
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_downgrade:1114
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_downgrade_esd:749
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type}
sybsystemprocs..sp_drop_all_qplans:91
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type}
sybsystemprocs..sp_drop_all_qplans:96
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_drop_metrics:61
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_drop_metrics:103
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_drop_metrics:114
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_drop_qpgroup:136
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_drop_qplan:66
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
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, sequence]
sybsystemprocs..sp_drop_query_tuning:99
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:99
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_drop_query_tuning:99
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_drop_query_tuning:110
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type}
sybsystemprocs..sp_drop_query_tuning:111
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dropexternlogin:143
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_dropgroup:193
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
sybsystemprocs..sp_dropgroup:248
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {langid}
sybsystemprocs..sp_droplanguage:148
SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {langid}
sybsystemprocs..sp_droplanguage:184
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_dropremotelogin:202
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dropremotelogin:246
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dropsegment:172
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dropsegment:267
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dropserver:139
SARG Candidate index: syscoordinations.csyscoordinations unique clustered
(xactkey, participant, owner)
Intersection: {owner}
sybsystemprocs..sp_dropserver:324
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_dropuser:212
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:239
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:242
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {grantor}
sybsystemprocs..sp_dropuser:248
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:250
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:270
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, uid}
sybsystemprocs..sp_dropuser:451
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:532
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:558
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:566
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid}
sybsystemprocs..sp_dropuser:569
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype}
sybsystemprocs..sp_drv_getcolumnprivileges:137
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
sybsystemprocs..sp_drv_getcolumnprivileges:278
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype}
sybsystemprocs..sp_drv_gettableprivileges:141
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
sybsystemprocs..sp_drv_gettableprivileges:263
SARG Candidate index: syscoordinations.csyscoordinations unique clustered
(xactkey, participant, owner)
Intersection: {owner}
sybsystemprocs..sp_dtx_purge_completedxacts:70
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid}
sybsystemprocs..sp_encryption:876
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_encryption:877
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:1498
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:1498
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:1499
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:1499
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {colid}
sybsystemprocs..sp_encryption:1612
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_encryption:2104
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid, type}
sybsystemprocs..sp_encryption:2196
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_encryption:2648
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_encryption:2649
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {type}
sybsystemprocs..sp_encryption:2709
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_encryption:2710
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid, type}
sybsystemprocs..sp_encryption:2791
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid, type}
sybsystemprocs..sp_encryption:2866
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid, type}
sybsystemprocs..sp_encryption:2936
SARG Candidate index: sysencryptkeys.csysencryptkeys unique clustered
(id, type, uid)
Intersection: {uid, type}
sybsystemprocs..sp_encryption:3011
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:3146
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:3146
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:3147
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:3147
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:300
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_extendsegment:342
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_filter_metrics:116
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_find_qplan:109
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey, type, sequence]
sybsystemprocs..sp_find_qplan:110
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:111
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_fixindex:231
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:684
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:939
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:940
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:1060
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:1083
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:1084
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_help:1156
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:128
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:138
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type, sequence}
sybsystemprocs..sp_help_qpgroup:172
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid, type, sequence}
sybsystemprocs..sp_help_qpgroup:180
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {hashkey}
Uncovered: [uid, id, type, sequence]
sybsystemprocs..sp_help_qpgroup:213
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:238
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey]
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:243
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_help_qpgroup:243
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:248
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:260
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_help_qpgroup:260
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:265
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:277
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_help_qpgroup:277
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:282
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:296
JOIN Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
Uncovered: [uid, gid, hashkey]
sybsystemprocs..sp_help_qpgroup:296
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {gid}
sybsystemprocs..sp_help_qpgroup:301
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_help_qplan:132
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type, id}
sybsystemprocs..sp_help_qplan:144
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_help_rep_agent:65
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:620
JOIN Candidate index: syspartitions.csyspartitions unique clustered
(id, indid, partitionid)
Intersection: {partitionid}
Uncovered: [indid]
sybsystemprocs..sp_helpartition:676
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:121
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpdb:128
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpdb:135
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpdb:142
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpdb:149
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpdb:199
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:774
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:775
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_helpdb:778
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:363
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_helpindex:453
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_helpindex:454
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpmaplogin:61
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:87
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helpmaplogin:87
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:86
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:90
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helprotect:323
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_helprotect:327
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_helprotect:577
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: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:194
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:228
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:261
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:294
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_getcolumnprivileges:329
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, predid)
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, predid)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:69
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
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, predid)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:92
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
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, predid)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:114
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
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, predid)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:136
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
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, predid)
Intersection: {protecttype, action}
sybsystemprocs..sp_ijdbc_gettableprivileges:160
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
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, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
sybsystemprocs..sp_ijdbc_stored_procedures:190
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
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:161
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_jdbc_fkeys:176
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_jdbc_fkeys:205
SARG Candidate index: sysreferences.csysreferences clustered
(tableid, frgndbname)
Intersection: {frgndbname}
sybsystemprocs..sp_jdbc_fkeys:246
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid}
Uncovered: [id, number]
sybsystemprocs..sp_jdbc_getbestrowidentifier:183
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:225
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {sequence}
sybsystemprocs..sp_jdbc_stored_procedures:116
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
sybsystemprocs..sp_jdbc_stored_procedures:203
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {sequence}
sybsystemprocs..sp_jdbc_stored_procedures:223
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
sybsystemprocs..sp_jdbc_stored_procedures:310
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {sequence}
sybsystemprocs..sp_jdbc_stored_procedures:335
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
sybsystemprocs..sp_jdbc_stored_procedures:352
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_locklogin:203
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_logdevice:114
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_logdevice:139
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_logiosize:257
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_logiosize:266
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:196
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_maplogin:246
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_maplogin:279
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:451
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_maplogin:452
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:482
SARG Candidate index: spt_mda.spt_mda_ind unique
(mdinfo, mdaver_end, srvver_end)
Intersection: {srvver_end, mdaver_end}
sybsystemprocs..sp_mda:109
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute}
Uncovered: [object, object_info1, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_memlog:234
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_merge_dup_inline_default:116
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {type, number, sequence}
sybsystemprocs..sp_merge_dup_inline_default:153
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {texttype, colid, number, colid2}
sybsystemprocs..sp_merge_dup_inline_default:157
SARG Candidate index: #defval_tab.i1 unique
(uid, inline_default)
Intersection: {inline_default}
sybsystemprocs..sp_merge_dup_inline_default:174
SARG Candidate index: #defval_tab.i1 unique
(uid, inline_default)
Intersection: {inline_default}
sybsystemprocs..sp_merge_dup_inline_default:186
SARG Candidate index: syscomments.csyscomments unique clustered
(id, number, colid2, colid, texttype)
Intersection: {colid, number, colid2}
sybsystemprocs..sp_merge_dup_inline_default:456
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_merge_dup_inline_default:461
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {type, number, sequence}
sybsystemprocs..sp_merge_dup_inline_default:464
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_modifylogin:851
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_modifylogin:900
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_modifylogin:914
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_modifylogin:928
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
Uncovered: [grantor, protecttype, predid]
sybsystemprocs..sp_modifystats:335
JOIN Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray, indid}
Uncovered: [partitionid, statid, sequence]
sybsystemprocs..sp_modifystats:780
JOIN Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray, indid}
Uncovered: [partitionid, statid, sequence]
sybsystemprocs..sp_modifystats:790
JOIN Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray, indid}
Uncovered: [partitionid, statid, sequence]
sybsystemprocs..sp_modifystats:805
JOIN Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray, indid}
Uncovered: [partitionid, statid, sequence]
sybsystemprocs..sp_modifystats:815
JOIN Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray, indid}
Uncovered: [partitionid, statid, sequence]
sybsystemprocs..sp_modifystats:830
JOIN Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray, indid}
Uncovered: [partitionid, statid, sequence]
sybsystemprocs..sp_modifystats:840
JOIN Candidate index: #old_new_values.densities_CI unique clustered
(indid, partitionid, colidarray)
Intersection: {colidarray}
Uncovered: [indid, partitionid]
sybsystemprocs..sp_modifystats:890
JOIN Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray}
Uncovered: [indid, partitionid, statid, sequence]
sybsystemprocs..sp_modifystats:890
JOIN Candidate index: #old_new_values.densities_CI unique clustered
(indid, partitionid, colidarray)
Intersection: {colidarray}
Uncovered: [indid, partitionid]
sybsystemprocs..sp_modifystats:907
JOIN Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray}
Uncovered: [indid, partitionid, statid, sequence]
sybsystemprocs..sp_modifystats:907
JOIN Candidate index: #old_new_values.densities_CI unique clustered
(indid, partitionid, colidarray)
Intersection: {colidarray}
Uncovered: [indid, partitionid]
sybsystemprocs..sp_modifystats:924
JOIN Candidate index: sysstatistics.csysstatistics unique clustered
(id, indid, partitionid, statid, colidarray, formatid, sequence)
Intersection: {colidarray}
Uncovered: [indid, partitionid, statid, sequence]
sybsystemprocs..sp_modifystats:924
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_monitor_list:152
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:179
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_odbc_fkeys:245
SARG Candidate index: sysreferences.csysreferences clustered
(tableid, frgndbname)
Intersection: {frgndbname}
sybsystemprocs..sp_odbc_fkeys:294
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_odbc_getindexinfo:208
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {number}
sybsystemprocs..sp_odbc_getprocedurecolumns:242
SARG Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {number}
sybsystemprocs..sp_odbc_getprocedurecolumns:449
JOIN Candidate index: syscolumns.csyscolumns unique clustered
(id, number, colid)
Intersection: {colid}
Uncovered: [id, number]
sybsystemprocs..sp_odbc_getversioncolumns:212
SARG Candidate index: sysprocedures.csysprocedures unique clustered
(id, number, type, sequence)
Intersection: {sequence}
sybsystemprocs..sp_odbc_stored_procedures:100
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
sybsystemprocs..sp_odbc_stored_procedures:195
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {action}
sybsystemprocs..sp_odbc_stored_procedures:217
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
sybsystemprocs..sp_odbc_tables:315
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {action}
sybsystemprocs..sp_odbc_tables:340
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: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype}
sybsystemprocs..sp_oledb_getcolumnprivileges:147
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:417
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {protecttype}
sybsystemprocs..sp_oledb_gettableprivileges:135
SARG Candidate index: sysobjects.ncsysobjects unique
(name, uid)
Intersection: {uid}
sybsystemprocs..sp_oledb_primarykey:83
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
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, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
sybsystemprocs..sp_oledb_stored_procedures:198
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {action}
sybsystemprocs..sp_oledb_stored_procedures:220
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
sybsystemprocs..sp_oledb_tables:354
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {action}
sybsystemprocs..sp_oledb_tables:379
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
sybsystemprocs..sp_oledb_views:296
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {action}
sybsystemprocs..sp_oledb_views:321
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_passwordpolicy:232
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:327
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_passwordpolicy:330
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:331
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:341
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:342
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_passwordpolicy:343
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_placeobject:174
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_plan_dbccdb:89
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_plan_dbccdb:92
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_plan_dbccdb:95
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:139
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_post_xpload:172
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_post_xpload:178
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_post_xpload:189
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_post_xpload:197
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_remoteoption:201
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_remoteoption:362
SARG Candidate index: sysremotelogins.csysremotelogins unique clustered
(remoteserverid, remoteusername)
Intersection: {remoteusername}
sybsystemprocs..sp_remoteoption:387
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_rename:193
SARG Candidate index: syspartitions.nc2syspartitions unique
(id, indid, name)
Intersection: {name}
sybsystemprocs..sp_rename:195
SARG Candidate index: sysindexes.csysindexes unique clustered
(id, indid)
Intersection: {indid}
sybsystemprocs..sp_rename:333
SARG Candidate index: syspartitions.nc2syspartitions unique
(id, indid, name)
Intersection: {name}
sybsystemprocs..sp_rename:354
SARG Candidate index: spt_values.spt_valuesclust clustered
(number, type)
Intersection: {type}
sybsystemprocs..sp_renamedb:172
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_replication_path:1451
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, object_cinfo]
sybsystemprocs..sp_replication_path:1451
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {id}
sybsystemprocs..sp_set_qplan:84
JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute}
Uncovered: [object, object_info2, object_info3, object_cinfo]
sybsystemprocs..sp_shmdumpdisp:151
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:55
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type}
sybsystemprocs..sp_show_query_tuning:67
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:71
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:71
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:76
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:76
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:82
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:82
SARG Candidate index: sysqueryplans.csysqueryplans unique clustered
(uid, gid, hashkey, id, type, sequence)
Intersection: {type}
sybsystemprocs..sp_show_query_tuning:94
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:98
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:98
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:103
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:103
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:109
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:109
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_spaceusage:431
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:415
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:456
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:459
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:460
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:723
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:724
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_spaceused:822
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:119
JOIN Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
sybsystemprocs..sp_stored_procedures:214
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {action}
sybsystemprocs..sp_stored_procedures:236
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_sysmon:956
SARG Candidate index: sysconfigures.csysconfigures unique clustered
(name, parent, config)
Intersection: {parent}
sybsystemprocs..sp_sysmon:973
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, predid)
Intersection: {uid}
Uncovered: [id, grantor, protecttype, predid]
sybsystemprocs..sp_tables:336
SARG Candidate index: sysprotects.csysprotects unique clustered
(id, action, grantor, uid, protecttype, predid)
Intersection: {action}
sybsystemprocs..sp_tables:361
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:118