>>>Yes, I also suspected index corruption.
>>
>>Meneer Meester was definitely
not referring to index corruption.
>>
>>A corrupt index would give you wrong results.
>>
>>An unbalanced index would give you correct results, but it may be very slow in doing so.
>>
>>I suspect that a REINDEX should be enough to correct this situation.
>>
>>Hilmar.
>
>I can not do it. This operation should be done directly on the server. :(((
And yet, the explanation of Walter makes perfect sense; and REINDEX seems the only way to make the query faster.
Can't you send a small maintenance program, to be used on the server?
Or at least get a copy of the database to test locally, to test Walter's hypothesis?
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)