SQL Code Smells: Heap Tables
You inherit a database and start digging through the schema. Everything looks reasonable on the surface until you notice a handful of tables with no clustered index. No obvious reason. They just never got one. In some cases they have been sitting that way for years, quietly degrading read and write performance while nobody thought to look. Heap tables are one of those code smells that tend to accumulate in the background. They do not cause immediate errors, they do …