Locate is code that is cryptic and hard to maintain? That's what's screwed up.

If you'd look at my FPA articles, you'll find that I used a routine to determine whether to use GO TOP or LOCATE depending on the existance of a filter condition. I don't see how knowing when to use locate is any different than knowing when and how to Rushmore optimize. Its a matter of learning and ability.

I don't comment every sql with "please see index expression so and so to understand Rushmore optimization"