ordering_operation: EXPLAIN FORMAT=JSON knows everything about ORDER BY processing

(Sveta Smirnova) We’ve already discussed using the ORDER BY clause with subqueries. You can also, however, use the ORDER BY clause with sorting results of one of the columns. Actually, this is most common way to use this clause.

Read More - Register for Free Membership