>>>>I just tested this a few times and switched the order around. It appears you are correct. While the time changes depending on whether it is first, 2nd, 3rd, etc in the order (OCCURS() versus $ etc), $ does seem to be consistently the fastest.
>>>
>>>In Boris tests OCCURS() was the winner over $.
>>
>>:-)
>>No way!
>>
>>? [$], SECONDS()-m1
>>? [OCCURS], SECONDS()-m1
>>
>
>Yes, now I see that I misread. You're right, $ is the fastest here in native functions.
>
>I was thinking we may try API solution, but when I was ready to research I was interrupted. But we repaired tables using CmRepair - it was my first time trying it.
And HOW I could UPDATE my previous reply to you when I get answer to it?
(Because I just saw what is the quotation to my answer and what is the updated one :o)))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.