Code Tidy - Pastebin

New     Fork     Embed     View raw     Report

MySQL Indexing - text

Embed

You can embed this paste into a blog or website with this code:

<iframe class="codetidy" type="text/html" width="100%" src="http://codetidy.com/paste/embed/2886" frameborder="0"></iframe>

Add comment

Captcha
  1. mysql> EXPLAIN SELECT * FROM abcd tick WHERE tick.ID LIKE '74597';?
  2. +----+-------------+-------+------+------------------------+------+---------+---?
  3. ---+------+-------------+?
  4. | id | select_type | table | type | possible_keys          | key  | key_len | re?
  5. f  | rows | Extra       |?
  6. +----+-------------+-------+------+------------------------+------+---------+---?
  7. ---+------+-------------+?
  8. |  1 | SIMPLE      | tick  | ALL  | email_extid,abcd,abcde | NULL | NULL    | NU?
  9. LL |  161 | Using where |?
  10. +----+-------------+-------+------+------------------------+------+---------+---?
  11. ---+------+-------------+?
  12. 1 row in set (0.00 sec)?
  13.  ?
  14. mysql> EXPLAIN SELECT * FROM abcd tick WHERE tick.ID = '74597';?
  15. +----+-------------+-------+------+------------------------+-------------+------?
  16. ---+-------+------+-------+?
  17. | id | select_type | table | type | possible_keys          | key         | key_l?
  18. en | ref   | rows | Extra |?
  19. +----+-------------+-------+------+------------------------+-------------+------?
  20. ---+-------+------+-------+?
  21. |  1 | SIMPLE      | tick  | ref  | email_extid,abcd,abcde | email_extid | 4?
  22.    | const |    1 |       |?
  23. +----+-------------+-------+------+------------------------+-------------+------?
  24. ---+-------+------+-------+?
  25. 1 row in set (0.00 sec)?
© 2011 Code Tidy