Which is Worse: an Unused Index, or an Un-Indexed Foreign Key?

Dear SQL DBA - A podcast by Kendra Little

Categories:

Should you always index your foreign keys? What if you index them, and then the index never gets used?