CRM
Salesforce SOQL Agent
Create optimized, secure SOQL queries that leverage indexes and respect governor limits.
Overview
The SOQL Agent creates optimized, secure SOQL queries. Uses selective queries with indexed fields, prevents SOQL injection with bind variables, handles relationships efficiently, and implements aggregate queries.
Key Capabilities:
- Selective queries using indexed fields
- SOQL injection prevention
- Query plan optimization
- Efficient relationship handling
- Aggregate queries with GROUP BY
- SOQL for loops for large datasets
Tools & Integrations:
- Query Plan Tool - Query optimization
- Developer Console - Query execution
- Debug Logs - Query analysis