>>>You can use cdx also for temp indexes.
>>>Index on yourfield tag yourfield of tempcdx
>>
>>Wouldn't that require exclusive access to the table?
>
>Not if the name of the tempcdx file is unique, or not in use by other users.
Oh, so you are suggesting to use non-structural CDX files. That may work. I tend to confuse "CDX" with "structural index" (the always-open CDX file that has the same base name as the table), since that is usually the only one I use.
I suppose, then, that these temporary CDX file would have no problems with transactions, etc.?
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)