Foreign Key fields not indexed

[lchen-2101]

Short description explaining the high-level reason for the new issue.

Current behavior

submission table in the filing database with foreign key reference fields are not indexed, which slows down query performance. e.g. select * from submission where filing = 244; which only returned 181 rows at time of writing took 2 mins to query.

through api:
https://{filing-api-url}/filing/v1/filing/institutions/1234364890REGTECH002/filings/2024/submissions

Expected behavior

Query should be a lot more performant when properly indexed

tables:

• submission:
  • only has index on pk, and filing_counter, no index on filing.