Jump to content


Photo

Explain SQL


  • Please log in to reply
1 reply to this topic

#1 s4surbhi2218

s4surbhi2218

    Advanced Member

  • Members
  • PipPipPip
  • 54 posts

Posted 18 February 2013 - 02: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?

thanks
Have a great 2013!!

#2 fenway

fenway

    MySQL Si-Fu / PHP Resident Alien

  • Moderators
  • 16,193 posts
  • LocationToronto, ON

Posted 18 February 2013 - 12: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

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com