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.