Advanced Indexing Strategies for Customized Tables

I got called in to debug a "critical performance issue" once. IFS form taking 50+ seconds to load. Queries timing out. Admins panicking. Everyone's frustrated. I pull up a SQL trace and look at the qu