Add indexes to DB tables for better performance
Problem
As mentioned by @shreyasagarwal here, there are a number of missing indexes from DB tables in the Customers Portal.
Proposal
Assess the current state of the DB, determine where indexes could be added (e.g. foreign keys), and add them through migrations.
Result
Improved performance of the Customers Portal.