IndexCountScan or any pushdown needs to happen the all the predicates must able to converted to exact range scans and passed to indexer (Query should not be able eliminate any rows further). Otherwise results will not correct. In your case Leading % can’t be converted to range scan. So it will not do IndexCountScan.