>>>>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.