In innoDB,If the repeatability of the secondary index is very high, will it greatly improve the count performance of MySQL?

60 views Asked by At

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.

0

There are 0 answers