SORT INREC OUTREC - which one is better inrec or outrec

[Chanti]

When it comes to performance issues in sort, which one performs better
is it INREC or OUTREC?

similarly omit cond or include cond?

[dbzTHEdinosauer]

the less data you have to sort, the less time the sort process will take.

[Frank Yaeger]

When it comes to performance issues in sort, which one performs better
is it INREC or OUTREC?

For COPY, it doesn't matter if you use INREC or OUTREC.

For SORT or MERGE, you would use INREC if you want to reformat the records before sorting or merging, or OUTREC if you want to reformat the records after sorting or merging.

If it doesn't matter whether you reformat the records before or after sorting, and your reformatting decreases the size of the records, it may be more efficient to use INREC instead of OUTREC.

If it doesn't matter whether you reformat the records before or after sorting, and your reformatting increases the size of the records, it may be more efficient to use OUTREC instead of INREC.

similarly omit cond or include cond?

The INCLUDE and OMIT statements are equivalent for performance. However, if you can remove records before sorting with an INCLUDE or OMIT statement, that can be more efficient than removing records after sorting with an INCLUDE or OMIT operand of an OUTFIL statement.

[Chanti]

Thank you frank, the explanation gave me a clear picture