RE: SQL query optimization

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Mike,

Here are a few suggestions based on what you have provided so far.
First, check out the manual at:

http://as400bks.rochester.ibm.com/pubs/html/as400/v5r1/ic2924/index.htm

I would try specifying the logical file rather than the physical. Next,
you
might try playing with the query options file. I would look at the
optimization
goal (first I/O sounds like what you might want) and statistic
limitation first.
To try the query options file, copy the qsys version into a development

library and specify that library on the chgqrya command. If find this
helps,
I can point you to some support I wrote to make it easier to use the
query
options file.

David Morris


>>> Mike_Smith@RGCResources.com 02/11/02 11:31AM >>>
Ok Darren,

here is the actual select statement that is being declared.

'SELECT QCCAT, QCCACT FROM QACAT00   ORDER BY QCCAT '...