Colin,

> Now this plan uses no Natural scans, does a couple thousand indexed
> reads and returns fairly quick...
>
> But what I want is:
> Where (((Table1.ForeignKey2 >= 962) or (Table1.ForiegnKey2 <= 973))
> and (Table1.Status = 8) and (Table4.ForeignKey1 = 170))
>
> As soon as I add this it puts in a Natural Scan and takes hours....

Please confirm which version of FB you are running?


Sean