> isn’t going to go any faster with an index Depends on the data, and the index. A covering index would almost certainly be faster. But you said analytics, whi

> isn’t going to go any faster with an index Depends on the data, and the index. A covering index would almost certainly be faster. But you said analytics, which implies large results from huge datasets, so it’s unlikely to fit into memory in the first place.