[FEATURE] Audit the code to add indexes where required

[Cingulara]

Is your feature request related to a problem? Please describe. Audit our code for where, order by, sort and make sure there is an index

Describe the solution you'd like Add any update scripts to run with the version update, so all indexes used are valid and match

Describe alternatives you've considered n/a

Additional context Need to do away with table scans...