Re: how to optimize this sql?

[h h]

root@localhost:legend 11:00:26>select count(distinct(is_deleted)) from legend_account_coupon\G
*************************** 1. row ***************************
count(distinct(is_deleted)): 2
1 row in set (0.19 sec)

root@localhost:legend 11:02:16>select count(distinct(shop_id)) from legend_account_coupon\G
*************************** 1. row ***************************
count(distinct(shop_id)): 289
1 row in set (0.26 sec)

shop_id ,is_deleted column has not very much different value,actually there are very loooooong list in IN clause