3 ms·
Alternatively, analytics databases don't use indices by design, as for most queries they need to shuffle entire datasets anyways. For example, https://dbdb.io/d
by purgatio 7y ago
Alternatively, analytics databases don't use indices by design, as for most queries they need to shuffle entire datasets anyways. For example, https://dbdb.io/db/vertica https://dbdb.io/db/vertica: "Indexes are not support in Vertica."
- paulddraper 7y agoIndexes are part of the SQL standard, so they are certainly pertinent for "SQL database" discussion.
- kjeetgill 7y agoPlenty of analytical databases still use indexes; bitmap indexes, date ranges, "clustered" indexes and even ordered/btree indexes all still come in handy because they can all help whittle down queries from billions to millions of records. They just need to be ready to do efficient full table scans.