Columns in Indexes

A colleague of mine was in the middle of altering a database schema given some optimizations he was applying to the existing system, when he started to run into a frequent annoyance that disallowed him the easy removal of some troublesome columns: index dependencies for a given column. In this particular instance, the database grew…