>>>>>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.?
>
>That's how I understand it. From help:
All IDX index files (non-structural, or non-CDX based, indexes) must be closed during transactions. Only structural indexes are supported within transactions.This part of the help looks contradictory. It looks as if some experimenting is required.
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)
