audit indexing throughout the database

[MoralCode]

We probably have a ton of inefficient indexes, like #427

Here are some resources https://jon.chrt.dev/2026/04/15/things-you-didnt-know-about-indexes.html

https://use-the-index-luke.com/