How a SQL database works

Re:How a SQL database works by purgatio on Thursday December 19, 2019 @04:12PM (#21839368)

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: "Indexes are not support in Vertica."

[ Parent | on HN ]

Re:How a SQL database works by paulddraper on Thursday December 19, 2019 @04:16PM (#21839399)

Indexes are part of the SQL standard, so they are certainly pertinent for "SQL database" discussion.

[ Parent | on HN ]

Re:How a SQL database works by kjeetgill on Friday December 20, 2019 @03:31AM (#21842529)

Plenty 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.

[ Parent | on HN ]