Term Kind Topic What it is
Covering Index Index-Only Scan concept Indexing An index that contains every column a query needs, so the query is answered from the index without reading the table at all.
Freshness Tiering Hot Index, Recent-Document Tier pattern Indexing Splitting a search corpus into a small aggressively-refreshed index of recent documents and a large lazily-refreshed main index, so sub-second freshness is paid for only on the documents that need it.
Index Selectivity metric Indexing The fraction of rows a predicate eliminates — the property that determines whether an index is worth using at all.
Indexing concept Indexing Auxiliary structures that turn a scan into a lookup — the highest-leverage database intervention and the one most often applied blindly.
Partial Index Filtered Index concept Indexing An index built over only the rows matching a predicate, so it is far smaller and cheaper to maintain than a full index.
Uber H3: Hexagonal Spatial Indexing H3, Hexagonal Hierarchical Index case-study Indexing Uber built and open-sourced a hexagonal grid index because uniform neighbour distance matters when you are analysing supply and demand across space.