#DateForumTypeThreadPost
306 Aug 2015 @ 06:04 PDTDatabaseReplySliding Window Merge Join Running for long timeThanks for your reply,   i rewrote the query using Volatile Tables and it resolved the issue.  
224 Jul 2015 @ 12:18 PDTDatabaseReplySliding Window Merge Join Running for long timeCorrect Volatile Table definition, please ignore previous:   create volatile table SAC_VT_1 AS (SEL * FROM  SANDBOX.STG_INS_POLICY_STEP_2_AUtO_PPI WHERE RISK_CODE='V1') WITH DA...
123 Jul 2015 @ 06:27 PDTDatabaseTopicSliding Window Merge Join Running for long timeHello Team,   Require help in tuning below query. with existing filter & join conditons i tried to tune the query but no major breakthrough in reducing Runtime and Total CPU. The query i...