index on str(acountno) + iif(invoicetotal > 0, "1", "0") tag anytagwillwork
Search on the same expression: select ... for str(acountno) + iif(invoicetotal > 0, "1", "0") = str(MyAccount) + "1"
For complete efficiency (not equal to optimization), be sure that you
don't have any index on deleted(). I am not talking about the filter, but about the index expression.
HTH, Hilmar.
>Hi Hilmar,
>
>One more question regarding this issue. If you remember I am searching invoice records for a specific account# and that have a total > 0.00.
>
>I was going to try to make a composite index on these 2 fields and check the speed. I'm not sure the best way to set up this new index.
>
>Any ideas,
>Paul
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)