We all know about that question, but still sometime we never give really care about that,..
'cause maybe we have kind of habit making an SQL view from a table/database that not close,.. even sometime it's very far from environment reality where our apps will be deployed,..

That has happened to me,..... then I begin to wondering what was went wrong,..

Then when I got started with a new project,... with a client that has very large database that's what it's all matter about,...

The FOXPRO'S RUSHMORE TECH realy make a difference,... but RUSHMORE always need exact comparable logical values before it's begin executing,...

So try your code in environment that has table(s) that contains about 20000-25000 records..:

You'll see the difference,..in peformance,.. but one thing important don't try that on PC or SERVER that have P-II 4000 Mhz,.. try it with a commonly used configuration for office's workstation,... or for more accurate see what's your client commonly used configuration,....!!!