Performance with Indexing

• H08.CR.DIV.DATA pure custom file

• Defined 20+ indicies on it

• 45721 records in file

• SELECT H08.CR.DIV.DATA WITH XCDD.STU.PROGREP.STATUS='V'

• Indexed: 50 milliseconds

• Non-indexed: 1432 milliseconds