We have a question about performance in quick reports that use one or more IAL’s.
Let’s say we have 3 IALs over CustomerOrderLines (and other tables but this is the main one), each building upon the previous one. In the 3rd IAL that the quick report uses, we want to pull the DistrictCode that is in CUST_ORD_CUSTOMER_ADDRESS_ENT.
Will it affect performance if we join CUST_ORD_CUSTOMER_ADDRESS_ENT in the 1st IAL or the quick report?
Any best practice to follow on something like this?
Best answer by william.klotz
View original