From "Justin Taylor" <jtaylor.0ab@xxxxxxxxx>To "MIDRANGE-L" <midrange-l@xxxxxxxxxxxxxxxxxx>
VE is recommending an index over QSYS/QADBXREF. The query in question is
using QSYS2.RECORD_LOCK_INFO. I've never seen an index recommended over a
QSYS table before. Is it a bad idea to create indexes over QSYS tables
(they'd be in a diff schema of course).
-- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.