>>HI Nadya,
>>
>>Have you tried to reindex the index? It might have become unbalanced.
>>Another cause might be that the table is highly fragmented over the disk. Did you try to defragment
>
>Unbalanced! I would never have thought of that. Is this a common problem in VFP?
>
>Hilmar.
Come to think of it, almost all my tables have a PK on a sequential number ("autoincremented") - that is, the table is already sorted. Would this be an invitation to an unbalanced index? Would it help to reindex regularly?
Hilmar.
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)
