TRANS_COMBINED_VIEW appears to be doing a UNION ALL where both sides of the UNION ALL are doing Cartesian joins. That seems quite unlikely to be the best approach. Are you certain that the view isn't missing some join conditions?
Yes. You are right they are trying to retrieving the data from 4 tables/Views using UNION ALL and equi join . But I couldn't find any join condition is missing.
Edited by: 966949 on Feb 5, 2013 12:48 PM
the JOIN condition and UNION ALL are working fine and retrieving the data within short span of time. I couldn't find any issue in Trans_..MV.
could you please look into this let me know any alternative way to dig the root cause for the performance issue.
I have only one account... Do you have any concerns to create any other account?
AS of now I don't have any plans to create multiple accounts. Because till I didn't face any issue with the current account I am getting good support like you people. SO why I do I go and create new accounts.