Impossible WHERE noticed after reading const tables

Posted by Vincent on September 25, 2011

mark it

在根据主键查询或者唯一性索引查询是出现:Extra: Impossible WHERE noticed after reading const tables

explain走到这个方式,会很慢,一个空表也是如此,在并发量高的情况下存在相互的等待,因为他要判断之。

如果直接走索引的方式,那么效率就非常高。

 

奇怪mysql要整这么个东西干啥

 

http://wangyuanzju.blog.163.com/blog/static/13029200691114035831/ --很详细


This work is licensed under a CC A-S 4.0 International License.