>>>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.
If it's not broken, fix it until it is.
My Blog