What MySQL Execution Plan Depends On

Well, the execution plan is the way that a database executes query, it usually depends on many things like the presence of indices, data stored in table, amount of the returned data and so on. I’ve already found that on MySQL it depends on something more, on the kind of storage engine being used. More you can find here: http://code.openark.org/blog/mysql/two-storage-engines-different-plans-part-i

Bookmark It

Related posts:

1. What MySQL Execution Plan Depends On – part 2 Another link about the way that MySQL prepares the execution...
2. MySQL SQL Mode Fun While looking for some information on the web, I found...
3. Another misleading “PostgreSQL vs MySQL review”!!! Yea… I wanted to write something as soon as I...
4. PostgreSQL Collation – part 1 PostgreSQL is (IMHO) much better than MySQL but unfortunately it ...
5. Why Use ORMs? Why Use ORMs? ORM aka Object Relational Mapping is a...