BookatlasTwo-Day MuleSoft → Salesforce Bootcamp
2 / 18 · Module 5 — Salesforce Data Model + SOQL · filtered: cheatsheet← prev⊞ allnext →

5.34Avoid querying unnecessary fields

Bad:

retrieve giant Account representation
even though you only need Id

Better:

SELECT Id
FROM Account
WHERE External_Customer_ID__c = :externalId

Benefits:

smaller payload
less memory
less serialization
clearer intent

Especially important inside integrations handling volume.