I think the practice is unlikely to be harmful when understood, but I worry about spreading misinformation. Maybe we could reword this?

* Consider indexing columns used as foreign keys, as they are often used in `WHERE` and `JOIN` clauses.