Robert martin wrote:

> AND sl.CancelFlag <> 'T'
>
> PLAN JOIN (SO INDEX (SUPPLYORDER_ENTITYREF),SL INDEX
> (SUPPLYLINE_SUPTRANREF,SUPPLYLINE_PACKSLPREF,SUPPLYLINE_SUPORDRREF))
>
> Returns 208 results in 1.359s If I change the last line to
> AND sl.CancelFlag <> 'F'
>
> The plan remains the same and the result is 334 records in 0.078s
>

Could some of this be an effect of caching? Running the first query
will get all the interesting parts of both tables into the cache, making
the second one quick.


Regards,


Ann