Re: query optimizer revisited - this shouldn't be this hard!

ok, reasonable enough.  so I change the opnqryf and the index to match each
other better, while having the same results.

CREATE INDEX HISTRY4LA
    ON HISTRY4 (HPEROD, HITEM, LMRKTC)

and

OPNQRYF FILE((HISTRY4))
QRYSLT('HPEROD *EQ "06" *AND HITEM *NE 0 *AND LMRKTC *NE "00"')
KEYFLD((HPEROD) (HITEM) (LMRKTC))

I ran again, and it says it considered my index, but rejected it because of
reason 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.