Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
Hi Tore
>1. If you share a table, and you need an index often, you create an incex in the structural index file by the command Index ox xx Tag yourtag. You do this ONCE, meaning only one time, meaning not two, three or many times, but ONCE. Period, no more discussion here. If you don't understand why, you MUST do some reading in Help. I repeat: you create an index tag ONCE, there is NEVER ever a need to create it more than once. You create index TAGs in only two situations: The first time you see that you will need it often, and after a computer crash.
Agreed!
>
>2. If you share a table, and you need a special index only on rare occations, like every two weeks, you create an index FILE, not tag, for that special purpose via Index on xx to yourtempfile, where "yourtempfile" is an unique file which you usually put on your LOCAL machine, and delete it after you don't need it anymore.
I would not do that. Build the tag as in point 1. Leave it there. Use SQL Select to build a temporary cursor using that index tag to optimize. That should be faster than accessing the entire table to do the index.
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