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

I agree, I read it many times without coming to a clear conclusion. But since I am busy preparing my house for the holiday season, I don't have the time to do it.