Skills
.Work. You
Rest

soql-optimization

Community

Speed up Salesforce data with optimized SOQL.

Software Engineering#performance#indexing#salesforce#soql#bulk#query-plan
Authorbhanu91221
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Salesforce data access often suffers from inefficient SOQL queries that cause slow performance and governor-limit pressure. This skill helps you analyze and optimize queries by interpreting query plans, identifying selective filters, and guiding indexing decisions.

Core Features & Use Cases

  • Query Plan tool usage: analyze query plans from Developer Console or Tooling API to assess performance characteristics.
  • Reading and interpreting plan fields: cardinality, leadingOperationType, relativeCost, and sobjectCardinality to guide optimizations.
  • Applying best practices: enforce LIMIT usage, avoid leading wildcards, optimize relationship queries, and design appropriate indexing strategies for common filters.
  • Real-world scenarios: bulk data loads, complex joins across related objects, and incremental query tuning to stay within governor limits.

Quick Start

Open Developer Console, run a SOQL query with the Query Plan tool, and apply the recommended optimizations to improve performance.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: soql-optimization
Download link: https://github.com/bhanu91221/claude-sfdx-iq/archive/main.zip#soql-optimization

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.