MySQL特异功能之:Impossible WHERE noticed after reading const tables
用EXPLAIN看MySQL的执行计划时经常会看到Impossible WHERE noticed after reading const tables这句话,意思是说MySQL通过读取“const tables”,发现这个查询是不可能有结果输出的。比如对下面的表和数据:
create table t (a int primary key, b int) engine = innodb;
转载
2012-03-19 09:13:00 ·
717 阅读 ·
0 评论