Forum Discussion

sureshsonti's avatar
sureshsonti
Icon for Helper II rankHelper II
8 years ago

RIGHT OUTER JOIN DIRECT QUERY

I am using the direct query by using 2 tables and I want to use RIGHT OUTER JOIN to do a merge. But it is taking a long time to merge the 2 tables and it is effecting the production environment. The ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI sureshsonti

 

Am not getting into the analysis of why Right outer join takes long time , but to get solution for your situation , Why dont you revrese the bale and use Left outer join which returns data in seconds?  Both appraoch are same.

 

Ex: You want Table A right outer join Table B. But, "Table B Left Outer Join Table A" also gives the same result.

 

Thanks

Raj

sureshsonti's avatar
sureshsonti
Icon for Helper II rankHelper II
8 years ago

I did the reverse as you said but I am missing some rows from the second table

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi

    It should not be the case. Obviously, you need only the matching row from the second table. If some rows misisng means,  how about the values of joining columns for those records ? Are they matching?

     

    Thanks
    Raj