Advertisement
Guest User

Untitled

a guest
Oct 18th, 2012
504
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. mysql> EXPLAIN SELECT distinct(vendorid) FROM products where pid in(select pid from orders_content WHERE oid='663');
  2. +----+--------------------+----------------+------+---------------+------+---------+-------+------+------------------------------+
  3. | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
  4. +----+--------------------+----------------+------+---------------+------+---------+-------+------+------------------------------+
  5. | 1 | PRIMARY | products | ALL | NULL | NULL | NULL | NULL | 9219 | Using where; Using temporary |
  6. | 2 | DEPENDENT SUBQUERY | orders_content | ref | oid,pid | oid | 4 | const | 1 | Using where |
  7. +----+--------------------+----------------+------+---------------+------+---------+-------+------+------------------------------+
  8. 2 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement