Non-Selective Query on Large Object

Overview

When querying large objects, non-selective queries take a very long-time and may cause different programmatic elements (such as Apex triggers or batch Apex classes) to fail.

Business Impact

Increased system downtime and inaccessibility, leading to decreased customer satisfaction and operational inefficiency.

Is your Salesforce solution affected by Non-Selective Query on Large Object?

Clayton detects anti-patterns and offers automated fix advice to kickstart your Well-Architected journey.

Scan your solution

Resources

Force.com SOQL Best Practice: Sort Optimization
Working with Very Large SOQL Queries
Large Data Volumes
Improve Performance of SOQL Queries using a Custom Index
Improve SOQL Query Performance - Selectivity and Custom Indexes
Make SOQL query selective

Incidence

How common is this issue?

Data not available

Exposure

How long do organizations remain exposed before fixing the problem?

Data not available

Frameworks

Trusted

Reliable

Scalability

Data Volume

Found a mistake?

If you think something is incorrect, missing or misleading please let us know.

Report an error