Hi Bruce!
Have you index on Deleted()? Is the left side of WHERE clause match the
index expression?
Have a happy day
Vladimir Shevchenko
> >Using sys(3054), optimize on, most queries I try, even the simplest,
show
> "None" for optimization level (occasionally I get a "Partial"). I hadn't
> Okay, I've made it up to mostly "partial" Rushmore by simplifying the
> indexes to one field...still haven't been able to get a "full",
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer