I just found out that in order to prevent full table scans during joins, I need to add indexes to my foreign keys in my rails app. But I'm unsure exactly what adding indexes to foreign keys means, how it works, and how it boosts performance.I just found out that in order to prevent full