These are two totally different use cases. Analytics generally means a full table scan or similar for each query, because you're e.g. taking an average of ever

These are two totally different use cases. Analytics generally means a full table scan or similar for each query, because you're e.g. taking an average of every value. You're talking about indexes which are to optimize retrieving a handful (or few thousand) of rows.