Forum Post: RE: joining 2 virtual tables runs forever or at least a very long time

I suggest searching the online kbase using "sql query plan" as the search string. It will return articles you can use to help determine the source of the problem. From: scottemick [mailto:bounce-scottemick@community.progress.com] Sent: Thursday, July 24, 2014 10:50 AM To: TU.OE.Development@community.progress.com Subject: [Technical Users - OE Development] joining 2 virtual tables runs forever or at least a very long time joining 2 virtual tables runs forever or at least a very long time Thread created by scottemick SELECT * FROM (SELECT R.RegionID , R.Name Region , E.EntityID , E.Name Location , Netsales , Year(dt_StartBusDate) Period , DayOfWeek(dt_StartBusDate) DOW FROM PUB.Entity E INNER JOIN PUB.eDB_MajorGroupTotals T ON E.EntityID = T.EntityID INNER JOIN PUB.Region R ON E.RegionID = R.RegionID WHERE dt_StartBusDate BETWEEN '07-20-14' AND '07-26-14' ) T1 INNER JOIN T1.RegionId = T2.RegionId AND T1.EntityId = T2.EntityId AND T1.DOW=T2.DOW (SELECT R.RegionID , R.Name Region , E.EntityID , E.Name Location , Netsales , Year(dt_StartBusDate) Period , DayOfWeek(dt_StartBusDate) DOW FROM PUB.Entity E INNER JOIN PUB.eDB_MajorGroupTotals T ON E.EntityID = T.EntityID INNER JOIN PUB.Region R ON E.RegionID = R.RegionID WHERE dt_StartBusDate BETWEEN '07-19-13' AND '07-25-13' ) T2 WITH (NOLOCK) Each of the two selects runs quickly and returns in a few sconds. Each returns 1,000 rows. So what does progress just sit and spin forever when I try to join the two together? Stop receiving emails on this subject. Flag this post as spam/abuse.

Continue reading...