# 2.6 The Cost of Fame  Getting a new suitcase into the Depot is an exhausting, multi-step process. First, the elephant has to argue with **[[Chapter 2/2.5 - The Bouncers and Dominoes#The Bouncers Constraints|The Bouncers]]** at the door. Then, dropping the suitcase might accidentally set off a chaotic chain reaction of **[[Chapter 2/2.5 - The Bouncers and Dominoes#The Domino Effect Triggers|Dominoes]]**. But even after the bureaucracy is finished, there is one final, heavy tax waiting for the elephant before he can go to sleep: **The Cost of Fame**. In the database depot, everyone wants your attention. If you are a popular table, you probably have half a dozen maps (indexes) pointing to you. The Index Clerk has a map of your IDs, the text-search parser has a map of your labels, and the geospatial tracker is following your coordinates on the globe. But fame comes with a heavy tax, and the tax-man doesn't care if it’s your un-birthday! ## The Synchronous Squeeze When the Lazy Elephant decides to add a new suitcase to the depot (an `INSERT`), or move an old one (an `UPDATE`), he can't just drop the data and head back to his hammock. The universe demands consistency: the maps must be perfect. He is legally required to wait while every single map-maker in the building updates their records. This process is **synchronous**. If you have 10 indexes, the elephant must stand there, tapping his foot and missing his tea, while 10 different animals scribble frantically in their notebooks. This is why adding "just one more index" can suddenly make your database feel like it's wading through cold molasses. ## The Speedy Pass: HOT Optimization The elephant, being fundamentally lazy, has found one brilliant way to cheat: **HOT (Heap Only Tuples)**. Imagine the elephant just wants to change the color of a sock inside a suitcase. If the index only cares about the **Suitcase ID**, and the elephant can fit the new version of the suitcase on the same **[[Chapter 1/1.2 - The Page|Page]]** (the same shipping container), he doesn't tell the map-makers anything. He just keeps his mouth shut! Instead, he leaves a tiny "Forwarding Address" on the old suitcase. When the Librarian eventually follows his map to the old spot, he sees the note, hops over to the new suitcase, and finds the data. This "HOT update" is lightning fast because none of the map-makers have to touch their notebooks. It’s a secret shortcut! ## When the Tax Man Cometh However, if you change a column that is _actually on the map_ (like changing the Suitcase ID itself), or if the shipping container is full, the shortcut fails. The tax man arrives, the tea party is cancelled, and the elephant must wait for the rewrite. Indexes are miracles for reading, but they are heavy weights for writing. Choose your fame wisely, or you might find yourself with a very large hat and a very small amount of time. --- [[Chapter 2/2.5 - The Bouncers and Dominoes|← 2.5 - The Bouncers and Dominoes]] | [[Chapter 2/2.0 - The Mighty Indexes|↑ 2.0 - The Mighty Indexes]] | [[Chapter 3/3.0 - The Battle for Efficiency|3.0 - The Battle for Efficiency →]]