Re: strange query performance

[Toa Sty]

Hi Eugene,

Have you run analyze table on these tables recently?

You can get strange joining orders sometimes if your index stats are very out of date.

Using STRAIGHT_JOIN is ok sometimes, but you have to remember to check occasionally to see if your data distribution has changed such that it's no longer the best join order for you. Without STRAIGHT_JOIN (but assuming reasonably up to date index stats) MySQL will usally do a very good job of choosing the best join order based on your data distribution etc.

Toasty

-----------------------------------------
email: 'toasty'*3 at gmail