How rows_sent can be more than rows_examined? This is an off-site link.  Please review our Terms of Service for additional information.

(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 a great candidate for optimization.

Read this article...

comments powered by Disqus