Selection set problem using -rx

[Ray Scheel]

Responding to my own question, I've figured out that reversing the order of
the individual field comparisons in the selection set yields the expected
result whether or not index scan is turned on, apparently since the fields
that would triggering an index scan were pulled off to the comparison side.

The following works as I intended:

::::::::::::::
att_cla/sel.yr_to_month
::::::::::::::
:@px:eqf:4
:@py:eqf:3

Ray 


Ray Scheel wrote: 
> I am scratching my head as to why that would cause problems only
> selectively.  I rebuilt all indexes earlier, though I'll admit I'm a bit
> foggy on exactly what the "index scan" feature does or how it works.  

Ray Scheel               ray.scheel at wsdtx.org 
Windham School District     Computer Services
Programmer                       936-291-5206