Steps to reproduce:
1. Reports have been reaching the community about databases not performing well anymore due to major amounts of data produced by Matterhorn.
2. Looking at the database scripts, there are many tables that do not define indices, thereby forcing database engines to do massive table scans
We need to review the database scripts and compare them with the SQL queries defined through JPA to determine JOIN conditions, WHERE clauses and other construct that may profit from database indices.