I have a query that has been working fine for ages (2+ years).
All of a sudden it went from taking 3 secs to 30+ to execute. The table indexes have minimal fragmentation, but rebuilding the indexes "fixes" it for about a day.
When I go to check the fragmentation it is around .5 (not bad). The table only sees about 100 inserts and another 100 updates a day.
There are no locks on the table when it happens. Any ideas of what to check?