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 best solutions below