>Your rule of thumb is incorrect in our case. Locate is 10 times slower than seek. Select is 100 times slower than seek. Select with set deleted off is 100 times faster than seek!?!



Nigel,

Do you really mean you found SELECT with set deleted off to be 100 times faster than SEEK?