Mike Yearwood
Toronto, Ontario, Canada
The fact is seek is faster if you have no filters in effect. Locate reads the entire index tag, seek hops through the tag by halves as it gets to the seek value. If your tables get larger, locate will get slower and slower while seek will stay relatively fast. That's why its recommended in tight loops.
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