Camel Monkey

Here’s a little trick I learned about organizing wide tables (a table with numerous columns):  consider sorting the columns alphabetically.

When I first heard and saw this, I thought it would have some negative consequences.  However, for as long as I worked with those tables, I have yet to find a drawback.

The main reason for this is that the efficiency when looking for data improves substantially.  Imaging looking for a column named “purchase_date” in table with fifty columns.  When your columns are alphabetical, it’s a cinch.