SOQL having IN clase takes long time to execute
Last updated 2015-09-03 ·Reference W-2378792 ·Reported By 6 users
SOQL on a small entity with an IN clause contains table with large number of rows, execution is taking longer than normal. This is because of new behavior introduced in Winter '15.
- Create a SOQL with 30 rows having in clause for a table with couple of million rows.
- Observe that it takes half the time to execute in Summer'14 org than Winter '15
If you are having issue, please contact Salesforce.com Support for a temporary fix.
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.