2 ms·
Probably a quicker way to get a developer to generate this same list of considerations is to say "explain the tradeoffs in adding an index to a column in a data
by derefr 14y ago
Probably a quicker way to get a developer to generate this same list of considerations is to say "explain the tradeoffs in adding an index to a column in a database table." We tend to search large tables much more frequently than large in-memory lists these days, so that's where any discussions you'll find on the topic are focused.
- jmduke 14y agoDumb/honest question from someone who isn't as experienced with database mechanics as he'd like to be: What exactly are the tradeoffs of adding an index?
- viraptor 14y agoStorage size of the index itself, insert/update performance. Also there may be very little gain from adding an index to a column with only few distinct values or a very skewed distribution (partitions may be a better approach in those cases).
- hnriot 14y agoyou have to build it and store, so the footprint of this data structure has now increased. If the array of numbers is mutable, the index also needs to be a modifiable structure (like a tree).