While that advice is a decent starting point; i.e. first look to foreign key fields used frequently in joins to place indexes on.However, beware putting indexes on any field (foreign key or otherwise) that is not particularly selective (a low rate of repetitive data).