Create index on Report_file table

CDCgov / prime-devops

Apache License 2.0

4 stars 2 forks source link

Create index on Report_file table #121

Closed victor-chaparro closed 3 months ago

victor-chaparro commented 3 months ago

This PR adds an index to the report_file table for the columns receiving_org_svc,receiving_org. This improves the performance for the daily data page.

https://github.com/CDCgov/prime-reportstream/pull/13902

JosiahSiegel commented 3 months ago

Index created on staging and prod databases