Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only