>I was surprised by Josh result: I didn't think that it would make that difference between a Rushmorized (!!!) LOCATE and a IndexSeek(). Even the Seek() was faster than the LOCATE.
The key difference between LOCATE and SEEK, is that with SEEK, the index is specfied, either in the SEEK command, or by the active index. Though they both are optimizable, each LOCATE command first has to find an index that it can work with, and
then move the pointer. This extra work can make a huge difference in a tight loop.
Erik Moore
Clientelligence