Jump to content


Explain SQL

  • Please log in to reply
1 reply to this topic

#1 s4surbhi2218

  • Members
  • PipPipPip
  • Advanced Member
  • 54 posts

Posted 18 February 2013 - 07:51 AM

Hey ,
i am wondering how to interpret an "explain select sql" in mysql
i found this http://www.slideshar...plain-explained over net but could not understand much can anyone help me .I want to know when we use explain command followed by some output how we interpret that o/p and make indexes?

Have a great 2013!!

#2 fenway

  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 18 February 2013 - 05:51 PM

Without a query, EXPLAIN is meaningless.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users