As any DBA worth their salt knows.
Index the many valued column, not the column with few discrete values.
Are you sure that's a good strategy if every unique index value requires you to buy a physical container?
alt Hacker News
Are you sure that's a good strategy if every unique index value requires you to buy a physical container?