the "in" use in mysql

huakaibird發表於2007-02-15

use in in mysql,if the field is indexed,the index is still useful,but when the data quantity is small relative to the param in "in" parentheses,mysql optimizer will use ALL TABLE SCAN instead.

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/545828/viewspace-899680/,如需轉載,請註明出處,否則將追究法律責任。

相關文章