>Hi Hilmar !
>
>I posted the message in the wrong forum, excuse me
>
>If I don't use recycling of my registers the file will probably be very big maybe with hundreds of thousands of registrations that I suppose myself will bring problems.
To avoid that, you can give the PACK command once a month. This command will eliminate all deleted records.
>When you suggest INDEX ON (DELETED() AND .T.) would not it be the same thing that not to have the index?
The difference is the following. With such an index, you can still quickly locate deleted records:
set order to ...
seek .T.
but the index will not automatically be used in Rushmore Optimization.
However, I would recommend just to PACK your tables once a month (or once a week, or once a fortnight), since this seems much simpler.
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)