Walter Meester
HoogkarspelNetherlands
Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
Mike,
I think you're right. I've should have said that an unoptimized LOCATE might be faster than a optimized one. SEEK will be faster in at least almost every case. There might be exceptions when using large index expressions on a very small table, though difference might be very small....
Of course this rule only applies when there are no filters in effect.
Walter,
>I doubt LOCATE is ever faster than seek. I have demonstrated that in views or other small tables, that an unoptimized LOCATE will be faster than indexing the view and then doing 1 seek.
Previous
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