Re: Mysql query optimiser performance question (second post)

2001-10-30 Thread Carl Troein
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

Mysql query optimiser performance question (second post)

2001-10-30 Thread SixK
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 - MyS