Query Optimization in IFS: The Hidden Performance Killer

3 PM on a Monday. Support tickets pouring in. Users can't open the customer form—it just hangs. You know that feeling? I do. I spent the next 2 hours digging through SQL traces, refreshing coffee, mut