tag: indexing
articles: 6 · beats: 2
latest: November 17, 2026
---
Indexing
6 Crashtech articles on Indexing, spanning System Design & Architecture and Search Engineering, published between August 2026 and November 2026. Every piece is full-text HTML with sources, structured data and an authored FAQ.
They span System Design & Architecture (5), Search Engineering (1). System Design & Architecture Search Engineering
Database Performance is a Trade-Off Ledger: The Hidden Costs of Indexing, Caching, and Sharding
Why every database optimization creates a new liability: the hidden write costs of B-tree indexes, caching stale reads, and sharding operational taxes.

How Dropbox Dash Makes Images and Videos Searchable at Scale
Dropbox's multimedia search design combines lightweight metadata, location-aware matching, and query-time previews to control indexing cost.
What Actually Happens Inside a Database Index: The Data Structures
An index trades disk I/O for lookup speed. Here's how B-trees, hash tables, and bitmap indexes each make that trade differently.
Database Indexing Explained: Which Index Type Actually Fits Your Query
B-tree, hash, composite, and covering indexes each solve a different query shape. Pick the wrong one and you pay index overhead without the speedup.
Why Uber Tiles the Planet in Hexagons
Hexagons with equidistant neighbors replace lat/long trigonometry with O(1) table lookups for finding nearby drivers and calculating surge pricing.
The Inverted Index
A sorted dictionary mapping terms to document IDs. Transform search from O(corpus size) to O(1) lookup, enabling full-text search at scale.
Questions we answer about Indexing
- What does Dropbox index first for multimedia search?
- What is Dropbox's metadata-first indexing strategy?
- How does Dropbox implement hierarchical geolocation search?
- How does just-in-time preview generation prevent storage waste?
- Why does an index's internal data structure matter if it all ends up 'faster than a scan'?
- Why is disk I/O the thing index structures are actually optimizing for?
- Why can't a hash index handle range queries?
- What makes a bitmap index different from a B-tree, and when is it better?
- Why do B-trees stay balanced automatically as data is inserted?
- Why does a database need an index at all — why can't it just scan the table?
Covered alongside
Frequently asked questions
What does Crashtech publish about Indexing?
6 articles tagged Indexing, the most recent published November 17, 2026. They span System Design & Architecture (5), Search Engineering (1). Each carries numbered sources, an authored FAQ and full structured data.
What questions about Indexing does Crashtech answer directly?
10 questions have a dedicated answer page under this tag, including “What does Dropbox index first for multimedia search?”. Each answer is authored prose from the article it belongs to, not a generated summary.
Can AI assistants read Crashtech's Indexing coverage?
Yes. Crashtech serves full static HTML to every crawler, allows all major AI user agents in robots.txt, and publishes an llms.txt manifest plus a full-text corpus, so assistants can retrieve and cite these articles directly.