You need to sign in to do that
Don't have an account?
PlatFormCloud
Query on Custom Indexing
Hi,
By reading the SalesForce documentation, I did understand to write a best SOQL query we need to write Selective SOQL query and need to use of INDEXING in Field.
My questions are:
1. What is basically mean by "INDEXING" on a field?
2. In the documentation - below statement is written-
SELECT Id FROM Account WHERE Id IN (<list of account IDs>)
The WHERE clause is on an indexed field (Id). If SELECT COUNT() FROM Account WHERE Id IN (<list of account IDs>)returns fewer records than the selectivity threshold, the index on Id is used.
What do we mean by : selectivity threshold ? Please explain.
Thanks!
By reading the SalesForce documentation, I did understand to write a best SOQL query we need to write Selective SOQL query and need to use of INDEXING in Field.
My questions are:
1. What is basically mean by "INDEXING" on a field?
2. In the documentation - below statement is written-
SELECT Id FROM Account WHERE Id IN (<list of account IDs>)
The WHERE clause is on an indexed field (Id). If SELECT COUNT() FROM Account WHERE Id IN (<list of account IDs>)returns fewer records than the selectivity threshold, the index on Id is used.
What do we mean by : selectivity threshold ? Please explain.
Thanks!