QJWT 3 Join or Sarg Without Index on temp table


  master..sp_autoformat:742
  master..sp_configure:260
  master..sp_configure:265
  master..sp_configure:270
  master..sp_configure:2053
  master..sp_procxmode:61
  master..sp_procxmode:137
  sybsystemprocs..sp_activeroles:182
  sybsystemprocs..sp_activeroles:183
  sybsystemprocs..sp_autoformat:742
  sybsystemprocs..sp_aux_computeprivs:615
  sybsystemprocs..sp_cmp_all_qplans:314
  sybsystemprocs..sp_cmp_all_qplans:369
  sybsystemprocs..sp_config_rep_agent:1105
  sybsystemprocs..sp_configure:260
  sybsystemprocs..sp_configure:265
  sybsystemprocs..sp_configure:270
  sybsystemprocs..sp_configure:2053
  sybsystemprocs..sp_ddlgen_database:575
  sybsystemprocs..sp_ddlgen_database:585
  sybsystemprocs..sp_displayroles:744
  sybsystemprocs..sp_displayroles:745
  sybsystemprocs..sp_downgrade:1616
  sybsystemprocs..sp_downgrade:1623
  sybsystemprocs..sp_downgrade_esd:1137
  sybsystemprocs..sp_downgrade_esd:1144
  sybsystemprocs..sp_encryption:1811
  sybsystemprocs..sp_encryption:1974
  sybsystemprocs..sp_estspace:733
  sybsystemprocs..sp_find_qplan:97
  sybsystemprocs..sp_find_qplan:118
  sybsystemprocs..sp_fkeys:284
  sybsystemprocs..sp_fkeys:286
  sybsystemprocs..sp_help:725
  sybsystemprocs..sp_help:747
  sybsystemprocs..sp_help_params:100
  sybsystemprocs..sp_helpapptrace:138
  sybsystemprocs..sp_helpdb:737
  sybsystemprocs..sp_helpdb:740
  sybsystemprocs..sp_helpdb:1039
  sybsystemprocs..sp_helprotect:582
  sybsystemprocs..sp_helprotect:650
  sybsystemprocs..sp_helprotect:664
  sybsystemprocs..sp_helprotect:813
  sybsystemprocs..sp_helprotect:816
  sybsystemprocs..sp_helprotect:823
  sybsystemprocs..sp_helprotect:934
  sybsystemprocs..sp_helprotect:937
  sybsystemprocs..sp_helprotect:943
  sybsystemprocs..sp_helprotect:1062
  sybsystemprocs..sp_helprotect:1065
  sybsystemprocs..sp_helprotect:1317
  sybsystemprocs..sp_helprotect:1368
  sybsystemprocs..sp_helprotect:1401
  sybsystemprocs..sp_helprotect:1462
  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:170
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:196
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:230
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:263
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:296
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:331
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:358
  sybsystemprocs..sp_ijdbc_getcolumnprivileges:398
  sybsystemprocs..sp_ijdbc_getindexinfo:157
  sybsystemprocs..sp_ijdbc_getindexinfo:171
  sybsystemprocs..sp_import_qpgroup:184
  sybsystemprocs..sp_jdbc_computeprivs:610
  sybsystemprocs..sp_jdbc_fkeys:242
  sybsystemprocs..sp_jdbc_fkeys:244
  sybsystemprocs..sp_merge_dup_inline_default:512
  sybsystemprocs..sp_merge_dup_inline_default:518
  sybsystemprocs..sp_merge_dup_inline_default:526
  sybsystemprocs..sp_merge_dup_inline_default:532
  sybsystemprocs..sp_monitor_connection:101
  sybsystemprocs..sp_monitor_connection:155
  sybsystemprocs..sp_monitor_connection:156
  sybsystemprocs..sp_monitor_connection:191
  sybsystemprocs..sp_monitor_connection:192
  sybsystemprocs..sp_monitor_connection:227
  sybsystemprocs..sp_monitor_connection:228
  sybsystemprocs..sp_monitor_list:151
  sybsystemprocs..sp_monitor_statement:72
  sybsystemprocs..sp_monitor_statement:109
  sybsystemprocs..sp_monitor_statement:110
  sybsystemprocs..sp_monitor_statement:143
  sybsystemprocs..sp_monitor_statement:144
  sybsystemprocs..sp_monitor_statement:179
  sybsystemprocs..sp_monitor_statement:180
  sybsystemprocs..sp_multdb_show:168
  sybsystemprocs..sp_odbc_fkeys:290
  sybsystemprocs..sp_odbc_fkeys:292
  sybsystemprocs..sp_oledb_datatype_info:137
  sybsystemprocs..sp_oledb_datatype_info:138
  sybsystemprocs..sp_oledb_fkeys:280
  sybsystemprocs..sp_oledb_fkeys:282
  sybsystemprocs..sp_plan_dbccdb:197
  sybsystemprocs..sp_procxmode:61
  sybsystemprocs..sp_procxmode:137
  sybsystemprocs..sp_setrepcol:313
  sybsystemprocs..sp_setrepcol:344
  sybsystemprocs..sp_setreptable:278
  sybsystemprocs..sp_setreptable:279
  sybsystemprocs..sp_sysmon_analyze:88
  sybsystemprocs..sp_sysmon_collect:367
  sybsystemprocs..sp_sysmon_collect:374
  sybsystemprocs..sp_sysmon_collect:385
  sybsystemprocs..sp_sysmon_collect:393
  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:119
  sybsystemprocs..sp_sysmon_kernel:120
  sybsystemprocs..sp_sysmon_kernel_threaded:146
  sybsystemprocs..sp_sysmon_kernel_threaded:147
  sybsystemprocs..sp_sysmon_kernel_threaded:148
  sybsystemprocs..sp_sysmon_kernel_threaded:149
  sybsystemprocs..sp_sysmon_kernel_threaded:193
  sybsystemprocs..sp_sysmon_kernel_threaded:204
  sybsystemprocs..sp_sysmon_kernel_threaded:362
  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