>Try this for a 1,000,000 record (same argument you used). Since it's is the norm that the tables are NOT filtered, and they *can* filter them. Also these main tables seldom reach such amount of records. (most mid-sized companies don't have 1,000,000 clients, articles, employees)
Walter,
Interesting you should ask. I just did and with a non-optimizable where condition it took 21 seconds to produce the result. Selecting 10,000 out of 1,000,000 records wihtout Rushmore.