And when you stack people in rows, the ones in the background look smaller than the ones in the foreground.— Virginia Postrel on glamour
So MySQL preferred to scan 10,000,000 rows, just so that the rows are generated in the right ORDER, and so no sorting is required, when it could have read 110 rows (where each row is a mere INT) and sort them in no time.— Planet MySQL
The estimated operator cost is 0\% and a nested loop is an efficient join when one or both of the inputs have a small number of rows, which is the case here.— Simple Talk rss feed
Hash joins are efficient for joining very large numbers of rows, which is why they appeared in the previous execution plan.— Simple Talk rss feed
TIM27 It would be cool if the rows were alternating colors to make viewing easier.— MacUpdate - Mac OS X

If you'd like to prod us on getting a pronunciation for this word, sign in (or sign up) and let us know.
Bubble size: how much this word was used in a year
Bubble height: used more or less than expected, vs. all uses evenly distributed
You can expect to see this word a few times a week.
Recently looked upgormandising · cottager · fodder · Brahman · racketeer |
Recent Favoritespygopagus · sanglant · Astacus · sweetbread · qualms |
Recent Pronunciationsqualms · poofter · oh for heaven's sake · embodies · silence |