Why using index caused more rows scanning?

Please take a look at the following query:

How to make GROUP BY force to use index?

I have the following query:

How to make COUNT(*) get executed quickly on a huge dataset?

I have the following query:

Why indexes on ENUMs doesn’t get applied?

I have the following query: