For your in-memory databases, do you need an index? – Daniel Lemire's blog

The post doesn't answer the question, but rather just lists some reasons indexes in in-memory databases could slow queries.