Description
create index ix5 on `beer-sample`(city);
select count from `beer-sample` where city = "Portland";
Above query does index scan, but ti also does KV operation due to STAR as count operand.
Consider this is special case of count(1) we can eliminate the KV operation. After change query become covered we may be able to use Index Scan count.