You are here:
ApexGuru Antipattern: SOQL with Unused Fields
Retrieving unused fields in SOQL queries increases overhead, resource consumption, and query execution time. It also increases heap size and causes governor limits to be exceeded, especially with large datasets or complex objects. Only include fields directly required by your logic. Regularly review and improve SOQL queries to remove unused fields.
Scope
Detection and recommendation
Detection Example
apex
SELECT id, KnowledgeArticleId, PublishStatus, Article_Tag__c
FROM Knowledge__kav
WHERE id = :recordIdRecommendation
Remove the unused KnowledgeArticleId field to optimize the query.
Include only fields directly required by your logic. Regularly review and optimize
SOQL queries.
SELECT id, PublishStatus, Article_Tag__c
FROM Knowledge__kav
WHERE id = :recordIdЭта статья решила вашу проблему?
Оставьте свой отзыв, чтобы мы могли стать лучше!
