Which three options can prevent your SOQL queries from being - ProProfs Discuss
Advertisement

Which three options can prevent your SOQL queries from being selective?

Which three options can prevent your SOQL queries from being selective?

Change Image    Delete

Asked by Pal, Last updated: Nov 09, 2024

+ Answer
Request
Question menu
Vote up Vote down

3 Answers

reeti.budhiraja

reeti.budhiraja

reeti.budhiraja
Reeti.budhiraja

Answered Aug 08, 2020

Using trailing % wildcards.
Using leading % wildcards.
Using NOT and != operators.

upvote downvote
Reply 

shibua

shibua

shibua
Shibua

Answered Jul 29, 2019

CDE -

Best practices mention leading wildcards to be avoided

Custom index on Deterministic formula field is a valid index - so can contribute to selective query

Leaves with the 3 other options

upvote downvote
Reply 

Pal

Pal

Pal
Pal

Answered Jun 23, 2018

Using a custom index on a deterministic formula field.
Using leading % wildcards.
Using NOT and != operators.
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.