Do Not #02 Use formula-field in WHERE clause

Illia Leshchuk
Nov 15, 2023

--

Using formula-field in WHERE clause slows down the SOQL query, leads to a TableScan leading operation, increased cost and cardinality, and eventually will result in “non-selective query” issues once the number of records on the object reaches certain threshold.

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

--

--

Illia Leshchuk
Illia Leshchuk

Written by Illia Leshchuk

A salesforce developer/architect

No responses yet

Write a response