QJWT 3 Join or Sarg Without Index on temp table


  sybsystemprocs..sp_activeroles:174
  sybsystemprocs..sp_activeroles:182
  sybsystemprocs..sp_activeroles:183
  sybsystemprocs..sp_autoformat:742
  sybsystemprocs..sp_aux_computeprivs:262
  sybsystemprocs..sp_aux_computeprivs:615
  sybsystemprocs..sp_aux_encrkey_lookup:12
  sybsystemprocs..sp_cmp_all_qplans:132
  sybsystemprocs..sp_cmp_all_qplans:138
  sybsystemprocs..sp_cmp_all_qplans:279
  sybsystemprocs..sp_cmp_all_qplans:334
  sybsystemprocs..sp_configure:225
  sybsystemprocs..sp_configure:230
  sybsystemprocs..sp_configure:235
  sybsystemprocs..sp_configure:1863
  sybsystemprocs..sp_ddlgen_database:474
  sybsystemprocs..sp_ddlgen_database:488
  sybsystemprocs..sp_ddlgen_database:551
  sybsystemprocs..sp_ddlgen_database:561
  sybsystemprocs..sp_displayroles:646
  sybsystemprocs..sp_displayroles:663
  sybsystemprocs..sp_displayroles:673
  sybsystemprocs..sp_displayroles:674
  sybsystemprocs..sp_downgrade:250
  sybsystemprocs..sp_dropuser:290
  sybsystemprocs..sp_dropuser:331
  sybsystemprocs..sp_dropuser:332
  sybsystemprocs..sp_encryption:1694
  sybsystemprocs..sp_encryption:1818
  sybsystemprocs..sp_encryption:2196
  sybsystemprocs..sp_encryption:2263
  sybsystemprocs..sp_encryption:2662
  sybsystemprocs..sp_encryption:2663
  sybsystemprocs..sp_encryption:2738
  sybsystemprocs..sp_encryption:2739
  sybsystemprocs..sp_estspace:733
  sybsystemprocs..sp_find_qplan:61
  sybsystemprocs..sp_find_qplan:73
  sybsystemprocs..sp_find_qplan:74
  sybsystemprocs..sp_find_qplan:82
  sybsystemprocs..sp_fkeys:284
  sybsystemprocs..sp_fkeys:286
  sybsystemprocs..sp_help:360
  sybsystemprocs..sp_help:507
  sybsystemprocs..sp_help:529
  sybsystemprocs..sp_help:1190
  sybsystemprocs..sp_help:1202
  sybsystemprocs..sp_help_params:100
  sybsystemprocs..sp_help_qpgroup:186
  sybsystemprocs..sp_helpapptrace:94
  sybsystemprocs..sp_helpartition:306
  sybsystemprocs..sp_helpartition:349
  sybsystemprocs..sp_helpartition:386
  sybsystemprocs..sp_helpartition:664
  sybsystemprocs..sp_helpcomputedcolumn:229
  sybsystemprocs..sp_helpcomputedcolumn:241
  sybsystemprocs..sp_helpconstraint:590
  sybsystemprocs..sp_helpconstraint:599
  sybsystemprocs..sp_helpdb:543
  sybsystemprocs..sp_helpdb:575
  sybsystemprocs..sp_helpdb:576
  sybsystemprocs..sp_helpdb:578
  sybsystemprocs..sp_helpdb:579
  sybsystemprocs..sp_helpdb:611
  sybsystemprocs..sp_helpdb:617
  sybsystemprocs..sp_helpdb:662
  sybsystemprocs..sp_helpdb:663
  sybsystemprocs..sp_helpdb:667
  sybsystemprocs..sp_helpdb:800
  sybsystemprocs..sp_helpdb:824
  sybsystemprocs..sp_helpdb:839
  sybsystemprocs..sp_helpdb:852
  sybsystemprocs..sp_helpdb:863
  sybsystemprocs..sp_helpdevice:90
  sybsystemprocs..sp_helpdevice:98
  sybsystemprocs..sp_helpdevice:106
  sybsystemprocs..sp_helpdevice:114
  sybsystemprocs..sp_helpdevice:131
  sybsystemprocs..sp_helpdevice:139
  sybsystemprocs..sp_helpdevice:147
  sybsystemprocs..sp_helpdevice:154
  sybsystemprocs..sp_helpdevice:164
  sybsystemprocs..sp_helpdevice:186
  sybsystemprocs..sp_helpdevice:195
  sybsystemprocs..sp_helpdevice:212
  sybsystemprocs..sp_helpdevice:220
  sybsystemprocs..sp_helpdevice:228
  sybsystemprocs..sp_helpdevice:235
  sybsystemprocs..sp_helpdevice:244
  sybsystemprocs..sp_helpdevice:261
  sybsystemprocs..sp_helpdevice:272
  sybsystemprocs..sp_helpdevice:297
  sybsystemprocs..sp_helpdevice:306
  sybsystemprocs..sp_helpdevice:312
  sybsystemprocs..sp_helpdevice:321
  sybsystemprocs..sp_helpdevice:323
  sybsystemprocs..sp_helpdevice:335
  sybsystemprocs..sp_helpdevice:343
  sybsystemprocs..sp_helpdevice:362
  sybsystemprocs..sp_helpdevice:388
  sybsystemprocs..sp_helpdevice:397
  sybsystemprocs..sp_helpdevice:411
  sybsystemprocs..sp_helpdevice:420
  sybsystemprocs..sp_helpdevice:429
  sybsystemprocs..sp_helpdevice:437
  sybsystemprocs..sp_helpdevice:450
  sybsystemprocs..sp_helpdevice:458
  sybsystemprocs..sp_helpdevice:471
  sybsystemprocs..sp_helpdevice:479
  sybsystemprocs..sp_helpdevice:495
  sybsystemprocs..sp_helpdevice:503
  sybsystemprocs..sp_helpdevice:522
  sybsystemprocs..sp_helpdevice:539
  sybsystemprocs..sp_helpdevice:540
  sybsystemprocs..sp_helpdevice:552
  sybsystemprocs..sp_helpdevice:560
  sybsystemprocs..sp_helpdevice:573
  sybsystemprocs..sp_helpdevice:581
  sybsystemprocs..sp_helpdevice:599
  sybsystemprocs..sp_helpindex:401
  sybsystemprocs..sp_helpindex:402
  sybsystemprocs..sp_helprotect:547
  sybsystemprocs..sp_helprotect:552
  sybsystemprocs..sp_helprotect:620
  sybsystemprocs..sp_helprotect:633
  sybsystemprocs..sp_helprotect:761
  sybsystemprocs..sp_helprotect:764
  sybsystemprocs..sp_helprotect:867
  sybsystemprocs..sp_helprotect:870
  sybsystemprocs..sp_helprotect:992
  sybsystemprocs..sp_helprotect:1005
  sybsystemprocs..sp_helprotect:1067
  sybsystemprocs..sp_helprotect:1069
  sybsystemprocs..sp_helprotect:1071
  sybsystemprocs..sp_helprotect:1105
  sybsystemprocs..sp_helprotect:1107
  sybsystemprocs..sp_helprotect:1110
  sybsystemprocs..sp_helprotect:1155
  sybsystemprocs..sp_helprotect:1157
  sybsystemprocs..sp_helprotect:1160
  sybsystemprocs..sp_ijdbc_aux_computeprivs:276
  sybsystemprocs..sp_ijdbc_aux_computeprivs:629
  sybsystemprocs..sp_ijdbc_fkeys:239
  sybsystemprocs..sp_ijdbc_fkeys:241
  sybsystemprocs..sp_ijdbc_fkeys:319
  sybsystemprocs..sp_ijdbc_fkeys:321
  sybsystemprocs..sp_ijdbc_fkeys:322
  sybsystemprocs..sp_ijdbc_fkeys:323
  sybsystemprocs..sp_ijdbc_fkeys:324
  sybsystemprocs..sp_ijdbc_getbestrowidentifier:114
  sybsystemprocs..sp_ijdbc_getbestrowidentifier:127
  sybsystemprocs..sp_ijdbc_getbestrowidentifier:169
  sybsystemprocs..sp_ijdbc_getbestrowidentifier:170
  sybsystemprocs..sp_ijdbc_getbestrowidentifier:175
  sybsystemprocs..sp_ijdbc_getbestrowidentifier:179
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:181
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:196
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:216
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:230
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:249
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:263
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:282
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:296
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:316
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:331
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:355
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:358
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:388
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:398
  sybsystemprocs..sp_ijdbc_getindexinfo:124
  sybsystemprocs..sp_ijdbc_getindexinfo:156
  sybsystemprocs..sp_ijdbc_getindexinfo:157
  sybsystemprocs..sp_ijdbc_getindexinfo:161
  sybsystemprocs..sp_ijdbc_getindexinfo:171
  sybsystemprocs..sp_ijdbc_getindexinfo:202
  sybsystemprocs..sp_ijdbc_getversioncolumns:123
  sybsystemprocs..sp_import_qpgroup:150
  sybsystemprocs..sp_jdbc_computeprivs:257
  sybsystemprocs..sp_jdbc_computeprivs:610
  sybsystemprocs..sp_jdbc_fkeys:243
  sybsystemprocs..sp_jdbc_fkeys:245
  sybsystemprocs..sp_jdbc_getcolumnprivileges:364
  sybsystemprocs..sp_jdbc_getcolumnprivileges:702
  sybsystemprocs..sp_memlog:212
  sybsystemprocs..sp_merge_dup_inline_default:461
  sybsystemprocs..sp_merge_dup_inline_default:490
  sybsystemprocs..sp_merge_dup_inline_default:496
  sybsystemprocs..sp_merge_dup_inline_default:504
  sybsystemprocs..sp_merge_dup_inline_default:510
  sybsystemprocs..sp_modifystats:611
  sybsystemprocs..sp_modifystats:621
  sybsystemprocs..sp_modifystats:668
  sybsystemprocs..sp_monitor_connection:105
  sybsystemprocs..sp_monitor_connection:159
  sybsystemprocs..sp_monitor_connection:160
  sybsystemprocs..sp_monitor_connection:195
  sybsystemprocs..sp_monitor_connection:196
  sybsystemprocs..sp_monitor_connection:231
  sybsystemprocs..sp_monitor_connection:232
  sybsystemprocs..sp_monitor_list:154
  sybsystemprocs..sp_monitor_procstack:126
  sybsystemprocs..sp_monitor_statement:76
  sybsystemprocs..sp_monitor_statement:113
  sybsystemprocs..sp_monitor_statement:114
  sybsystemprocs..sp_monitor_statement:147
  sybsystemprocs..sp_monitor_statement:148
  sybsystemprocs..sp_monitor_statement:183
  sybsystemprocs..sp_monitor_statement:184
  sybsystemprocs..sp_multdb_show:168
  sybsystemprocs..sp_odbc_computeprivs:315
  sybsystemprocs..sp_odbc_computeprivs:668
  sybsystemprocs..sp_odbc_fkeys:289
  sybsystemprocs..sp_odbc_fkeys:291
  sybsystemprocs..sp_oledb_computeprivs:321
  sybsystemprocs..sp_oledb_computeprivs:674
  sybsystemprocs..sp_oledb_datatype_info:128
  sybsystemprocs..sp_oledb_datatype_info:137
  sybsystemprocs..sp_oledb_datatype_info:138
  sybsystemprocs..sp_oledb_fkeys:280
  sybsystemprocs..sp_oledb_fkeys:282
  sybsystemprocs..sp_oledb_getprocedurecolumns:708
  sybsystemprocs..sp_plan_dbccdb:193
  sybsystemprocs..sp_procxmode:61
  sybsystemprocs..sp_procxmode:137
  sybsystemprocs..sp_setrepcol:302
  sybsystemprocs..sp_setrepcol:333
  sybsystemprocs..sp_setreptable:262
  sybsystemprocs..sp_setreptable:263
  sybsystemprocs..sp_setreptable:264
  sybsystemprocs..sp_shmdumpdisp:143
  sybsystemprocs..sp_spaceusage_object_populate:141
  sybsystemprocs..sp_spaceused:286
  sybsystemprocs..sp_sysmon:497
  sybsystemprocs..sp_sysmon_analyze:109
  sybsystemprocs..sp_sysmon_dcache_dtl:125
  sybsystemprocs..sp_sysmon_dcache_dtl:126
  sybsystemprocs..sp_sysmon_dcache_dtl:127
  sybsystemprocs..sp_sysmon_dcache_dtl:915
  sybsystemprocs..sp_sysmon_dcache_dtl:926
  sybsystemprocs..sp_sysmon_dcachestats:233
  sybsystemprocs..sp_sysmon_dcachestats:351
  sybsystemprocs..sp_sysmon_kernel:104
  sybsystemprocs..sp_sysmon_kernel:105
  sybsystemprocs..sp_sysmon_kernel_threaded:140
  sybsystemprocs..sp_sysmon_kernel_threaded:141
  sybsystemprocs..sp_sysmon_kernel_threaded:142
  sybsystemprocs..sp_sysmon_kernel_threaded:143
  sybsystemprocs..sp_sysmon_kernel_threaded:187
  sybsystemprocs..sp_sysmon_kernel_threaded:198
  sybsystemprocs..sp_sysmon_kernel_threaded:356
  sybsystemprocs..sp_sysmon_locks:166
  sybsystemprocs..sp_sysmon_locks:167
  sybsystemprocs..sp_sysmon_mdcache:445
  sybsystemprocs..sp_sysmon_mdcache:464
  sybsystemprocs..sp_sysmon_mdcache:483
  sybsystemprocs..sp_sysmon_mdcache:502
  sybsystemprocs..sp_sysmon_mdcache:521
  sybsystemprocs..sp_sysmon_mdcache:540