👨‍💼 Adding indexes to foreign keys is a no-brainer 99% of the time. For very small tables it's probably not worth it, but even with small tables it's not going to hurt anyway.

But we're not done. We've got an actual major performance issue with our user search query we need to address.