re:Query Optimizer Access Path Selection via Opnqryf

["Mike savino" <mikejsavino@xxxxxxxxxxx>]

* interestingly enough, the first one also recommended building the
following logical:

*FRMLC9, FRMLOC, SHPFOR.

Based on that, it appears that the Optimizer is smart enough to know that an 
exact match between the OPNQRYF Select and the Keys on the LF will speed up 
the selection.  Maybe Sorting the Results after the Select isn't as 
expensive as doing the Select in the First place.... Especially if the 
Results are a much smaller number of Rcds than the File itself contains.

*  RBTEST/SHP72PTDL2  4.
* 4 - The cost to use this access path, as determined by the optimizer, was
*higher than the cost associated with the chosen access method.

*  RBTEST/SHP72PTDL1  0, RBTEST/SHP72PTDL2  5.
*  5 - The keys of the access path did not match the fields specified for
*the ordering/grouping criteria.

It's interesting that the Optimizer came up with 2 different Reasons for not 
using the L2 File.  Wonder what's up with that?

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar ? get it now! 
http://clk.atdmt.com/AVE/go/onm00200415ave/direct/01/