- Using ant migration tool salesforce how to#
- Using ant migration tool salesforce full#
- Using ant migration tool salesforce code#
I have cleared my Salesforce Certified Platform App Builder – Transition Exam (SP17) today and here are the tips from my side to clear the exam: Which two Chatter Groups will show a seen-by count of people who viewed the post, in the Lightning Experience?Īns: B & C Salesforce Certified Platform App Builder – Transition Exam What action can be taken in Lightning, if you receive an approval requestĥ of 5. Contact, account, person account recordsĤ of 5. Contact, account, opportunity, quote recordsĭ. Contact, account, person account, opportunity recordsī. Where are the files and related records attached when a sales user converts a lead?Ī. How can an administrator allow users to choose different views of aģ of 5. Which two features best describe the new Lightning-optimized Log a CallĢ of 5. Salesforce Certified Administrator – Summer ’17 Release Examġ of 5. If the count of records returned by SELECT COUNT() FROM Account WHERE CustomField_c = ‘ValueA’ is lower than the selectivity threshold, and CustomField_c is indexed, the query is selective.Īlso, there are lot of links in stack exchange which discusses this issue and you can refer them as needed: As we saw in the previous example, the first filter isn’t selective. Here we have to see if each filter, when considered individually, is selective. SELECT Id FROM Account WHERE Name != ” AND CustomField_c = ‘ValueA’
![using ant migration tool salesforce using ant migration tool salesforce](https://focusonforce.com/wp-content/uploads/2016/06/image007.png)
Since Account is a large object even though Name is indexed (primary key), this filter returns most of the records, making the query non-selective.ģ. This index is typically used when the list of IDs contains only a few records.Ģ. SELECT Id FROM Account WHERE Name != ” Since the filter is on the ID field which is a standard and Primary Key field, it will have an index created at the DB. If SELECT COUNT() FROM Account WHERE Id IN ()returns fewer records than the selectivity threshold, the index on Id is used. The selectivity threshold is 10% of the first million records and less than 5% of the records after the first million records, up to a maximum of 333,333 records.A query is selective when one of the query filters is on an indexed field and the query filter reduces the resulting number of rows below a system-defined threshold.
Using ant migration tool salesforce how to#
How to determine if the query is selective?
![using ant migration tool salesforce using ant migration tool salesforce](https://slidetodoc.com/presentation_image_h2/5e7bdf6cca6498c5f31d2a9ade9c9eb9/image-33.jpg)
Using ant migration tool salesforce full#
If the SOQL query doesn’t contain a selective filter, the query is said to be un-selective and will require a full table scan. If a SOQL query contains at least 1 selective filter, the query is said to be selective. The performance of a SOQL will depend on the presence of a selective filter(in WHERE Clause). To avoid this error, ensure that the query is selective.
![using ant migration tool salesforce using ant migration tool salesforce](https://i.ytimg.com/vi/xe_3nqVWHCU/maxresdefault.jpg)
In our case, SOQL is inside the TriggerHandler which is called by the trigger.ĭevelopers receive this error message when a non-selective query in a trigger executes against an object that contains more than 200,000 records.
Using ant migration tool salesforce code#
Recently, in the project that I am working on, we have received this error in our apex code and this error occurs when querying large objects using SOQL (particularly for queries inside triggers).