Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Nov 18th, 2012  |  syntax: None  |  size: 0.86 KB  |  views: 26  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. mysql> explain SELECT id
  2.     -> FROM file
  3.     -> WHERE size IN
  4.     ->     ( SELECT size FROM tmpTab );
  5. +----+--------------------+--------+-------+---------------+----------+---------
  6. +------+-------+--------------------------+
  7. | id | select_type        | table  | type  | possible_keys | key      | key_len
  8. | ref  | rows  | Extra                    |
  9. +----+--------------------+--------+-------+---------------+----------+---------
  10. +------+-------+--------------------------+
  11. |  1 | PRIMARY            | file   | index | NULL          | filesize | 8
  12. | NULL | 21168 | Using where; Using index |
  13. |  2 | DEPENDENT SUBQUERY | tmpTab | ALL   | NULL          | NULL     | NULL
  14. | NULL |  3197 | Using where              |
  15. +----+--------------------+--------+-------+---------------+----------+---------
  16. +------+-------+--------------------------+
  17. 2 rows in set (0.00 sec)
clone this paste RAW Paste Data