parora
Well Known Member
Hi all,
Business View, V43121A, is a simple join between the F43121 and F4101 Table, linked based on ITM.
I would like to change the view to be a left outer join instead, based on ITM number, so I can pick up records in the F43121, which are not in the F4101.
This View is used in a handful of applications, and so will test these to ensure no adverse consequences.
However, what factors should be considered before doing this, i.e. I suspect records may take slightly longer to be retrieved by using the outer join, but what other things need to be taken into account?
Business View, V43121A, is a simple join between the F43121 and F4101 Table, linked based on ITM.
I would like to change the view to be a left outer join instead, based on ITM number, so I can pick up records in the F43121, which are not in the F4101.
This View is used in a handful of applications, and so will test these to ensure no adverse consequences.
However, what factors should be considered before doing this, i.e. I suspect records may take slightly longer to be retrieved by using the outer join, but what other things need to be taken into account?