Good day Where is it documented that the sequence of sort control statement does play a role in performance? My searches on Google, IBM-MAIN and DFSORT couldn't produce something 'hard and fast'...
My gut feeling is that INCLUDE COND=(1,8,CH,EQ,C'ABCDEFGH') SORT FIELDS=(1,8,CH,A) is better over this SORT FIELDS=(1,8,CH,A) INCLUDE COND=(1,8,CH,EQ,C'ABCDEFGH') for very LARGE input. Is this true or false? (If false, I can always do a COPY with INCLUDE and then do my SORT FIELDS) Thank you in advance. Groete / Greetings Elardus Engelbrecht ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
