MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » March 2014

Re: Checking for usage of CQE



fixed

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 http://www.dekko.com 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

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact