Hi Andreas!
Did you have an index on Deleted() expression too? It seems like your
filter is partially optimized...
Have a happy day
Vladimir Shevchenko
> organisation = '001'
>
> I have also an index on organisation to optimize the filter.
> But it is still very slow:
>
> e.g. Organisation '001' 150000 records
> Organisation '002' 250 records
>
> Without a filter it is quite fast.
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer