>>>I'd agree building indices on temporary cursors is ok, because the temporary cursor is not shared.
>>
>>Oh, right - there are actually at least two issues with temp indices. One is the time required to create them - and that was what I discussed. The other is the shared access. Visual Extend, of course, uses unique names for the temporary indices. (It also checks first, to see whether an index with the desired expression already exists.)
>
>If you're indexing on a cursor to a CDX, the cursor already has a unique name and thereby the CDX.
Yes, of course.
By the way, the Visual Extend framework which I mentioned as an example allows accessing the tables directly, as well as through local or remote views. I didn't update to the latest version (some resistance at work), but I understand those can work with CA as well.
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)
