SOQL and Indexes

Question

I am trying to understand more about "SOQL Query Performance" topic and I'm reading all the Salesforce docs.

I have a doubt when we have a WHERE clause with an AND condition.

The two docs on this topic are:

In the first document, we can read:

fieldExpression1 AND fieldExpression2 - shows 2 simple filters

but in the second one, there is a more detailed analysis of the AND condition and it is called composite filter.

Is the first document too shallow? Thanks

Nothing prevents both assessments from being correct. You do have two simple filters, and they make up a composite once joined by AND. — Adrian Larson, Apr 8, 2019 at 11:10

Santanu Boral · Accepted Answer · 2019-04-05 08:46:40Z

Is the first document too shallow?

No.

First document states overall guidance on how to make SOQL query selective and provides few important points.

It also provides following materials to fully understand how standard and custom indexes are different, and how they're employed.

You can see the 'Database Query & Search Optimization Cheat Sheet' is part of the first document those all the points in that pdf are not included.

I agree with you. The first document provides few important points but regarding the AND condition it provides different/wrong information. Isn't it? Thanks — vt89, Apr 5, 2019 at 10:26

1 Answer 1