Advertisement
Guest User

Untitled

a guest
Jan 12th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. EXPLAIN
  2. (select c1 from t1 group by c1,c2 order by c1 limit 1);
  3. id select_type table type possible_keys key key_len ref rows Extra
  4. 1 SIMPLE t1 ALL NULL NULL NULL NULL 2 Using filesort
  5. EXPLAIN
  6. select (select c1 from t1 group by c1,c2 order by c1 limit 1) as x;
  7. id select_type table type possible_keys key key_len ref rows Extra
  8. 1 PRIMARY NULL NULL NULL NULL NULL NULL NULL No tables used
  9. 2 SUBQUERY t1 ALL NULL NULL NULL NULL 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement