True enough - the 1000 record type includes the statement text, so you can get that in your output, sorted by optimizer used - nice!

On 3/4/2014 2:56 PM, rob@xxxxxxxxx wrote:
I could sort by optimizer used.

Rob Berendt
-- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 6928N 400E Kendallville, IN 46755 In order to see if a statement is optimized with CQE, it is necessary to run a monitor, then query over the data - I did not see, at the latest IBM i Access, an option to filter by optimizer used.

Return to Archive home page | Return to MIDRANGE.COM home page