>>What is the quickest way to get a record count of a table which excludes the deleted records? Is there some function or something which does this quickly, other than set deleted on and copy to, or running through each record and doing a count on ones which are not deleted?
>
>Also, if you add and index on DELETED() in your table, i guess the count will be faster ( not tested, sorry )
>
>Jaime
An index on deleted() can make many other commands slower. It is usually better not to have this index.
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)