Community

How indexes help the query optimizer with statistics

(Kent Milligan) Using the SQL performance monitor of operation navigator, I have scanned for the recommended index. In the index list, one was on QSYS2/SYSTABLES view on the QSYS/QADBXREF table. I have created the recommended index, but unfortunately it looks like the system does not use it and the

Read More - Register for Free Membership

Tags: