Which is Worse: an Unused Index, or an Un-Indexed Foreign Key?
Should you always index your foreign keys? What if you index them, and then the index never gets used?
Should you always index your foreign keys? What if you index them, and then the index never gets used?