FK Performance

Difficulty: Intermediate

Question

Should you always index Foreign Key columns?

Answer

Yes. Most joins and cascading deletes rely on these columns. Without an index, joining tables or deleting parent rows can become extremely slow.

Concepts covered

Indexing, Integrity