Some queries that were once fast are now approaching timeout limits. Indexes exist, but performance gains are inconsistent. As more filters and joins are added, tuning becomes difficult. I want to understand why SOQL optimization gets harder at scale?
Home/soql