As we know,mysql uses secondary index to improve the performance of count in innoDB. If we have a unique secondary index and a index with many duplicate values,which index will mysql prefer to use to complete a whloe table count?
select count(*) from table
searched mysql document.