It is FALSE. All of the control statements are read at initialization and the include fields are evaluated during the input phase of the sort to select only the records that meet the criteria.
Have a nice day, Dave Betten DFSORT Development, Performance Lead IBM Corporation email: [email protected] DFSORT/MVSontheweb at http://www.ibm.com/storage/dfsort/ IBM Mainframe Discussion List <[email protected]> wrote on 02/09/2009 07:52:51 AM: > 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 ---------------------------------------------------------------------- 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
