1

I'd like to find out the internals of how JOINss performed in MySQL. To be exact, the logic, etc. How and in which order it "does" things, including caring of indexes/etc,

Thanks!

Ian Nelson
  • 57,123
  • 20
  • 76
  • 103
alexeypro
  • 3,633
  • 7
  • 36
  • 49
  • I would start with this question http://stackoverflow.com/questions/770273/database-internals-where-to-begin – dsolimano Nov 14 '10 at 18:38
  • There's a whole host of MySQL internals stuff here: http://forge.mysql.com/wiki/MySQL_Internals – Chris J Nov 14 '10 at 22:18

1 Answers1

1

i suggest first understand how the cartesian product works. Then, go on to understand how join works which is a special case of the cartesian product. Try this link: http://dev.mysql.com/doc/refman/5.0/en/controlling-optimizer.html

Programmer
  • 6,565
  • 25
  • 78
  • 125