阅读背景:

WHERE子句中的条件顺序是否会影响MySQL性能?

来源:互联网 

Say that I have a long, expensive query, packed with conditions, searching a large number of rows. I also have one particular condition, like a company id, that will limit the number of rows that need to be searched considerably, narrowing it down to dozens from hundreds of thousands.Say that I have a long, expensive query, packed




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: