How rows_sent can be more than rows_examined?

(Peter Zaitsev) When looking at queries that are candidates for optimization I often recommend that people look at rows_sent and rows_examined values as available in the slow query log (as well as some other places). If rows_examined is by far larger than rows_sent, say 100 larger, then the query is

Read More - Register for Free Membership