简单的优化案例1

select count（*） fromworld.city where id>5;

 等价于

select (select count(*) from world.city) -count(*) from world.city where id <=5