Rows Returned ≠ Rows Examined ; why a query returning 10 rows may still scan millions.
Rows Returned measures the final result returned to the client. Rows Examined (or scanned) measures how much data the database execution engine had to load and inspect to return the final result. When






