@lxsameer same in any database. Index is just a sorted materialized (copy) of data for fast lookups

more indexes → more storage space, slower inserts

but faster lookups

@tonsky yeah i see, but I expected the indexes to contain only the “index field” like indexes in relational databases. I didn’t know that we store the complete datum