>Hi Hilmar
>
>That's very good, but you can make the index size somewhat smaller by using INDEX ON IIF(DELETED(),.T.,.F.). It seems the IIF(DELETED(),1,0) must be padding the 1 and 0 in the index to something bigger than .T./.F. There is a slight performance improvement too ;) You'd have to change how you count the records to: COUNT FOR IIF(DELETED(),.T.,.F.) = .T.
Interesting - I hadn't thought about that, but I think I have seen cases where integers use up more than 1 byte of space in the 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)