SixK writes:
> - MySql make all joins between tables before extracting the required
> rows
How do you mean? It can only start returning rows when all
tables that are needed have been joined, but of course it
doesn't create a temporary table with the product of all
tables before it starts to ret
Hello,
sorry, this is the second post, caue I had no reaction.
Just wanted to talk about the MySql Query Optimiser.
After having performance problems with some queries, I arrived to
thoses conclusions:
- The order of joins with constants and column have no effect on the
speed of the query
Hello,
Just wanted to talk about the MySql Query Optimiser.
After having performance problems with some queries, I arrived to
thoses conclusions:
- The order of joins with constants and column have no effect on the
speed of the query
- MySql make all joins between tables before extracting the
