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

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

Asked by Pal, Last updated: Apr 30, 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.