You are here:
Add Required Indexes for Industries Order Management Implementations
If your organization has, or expects to have, more than 200K records of an object in the Required Indexes table, you should add the required indexes to support them.
To see the indexes that are required for supporting CPQ objects, visit this page: Required Indexes for Vlocity CPQ Implementations
To have a custom index added to an org, open a case with Salesforce technical support and provide the exact SOQL queries with bind variables needed to create and test the index.
Order Management Objects | Required Indexes |
|---|---|
Orchestration Items |
|
Sample SOQL Queries Requiring Custom Indexes
The following sample SOQL queries require custom indexes. You might need to update the ID values in the WHERE clauses so that they refer to an actual record in your Salesforce org.
Orchestration Item Queries
vlocity_cmt__OrchestrationItem__c.vlocity_cmt__State__c
SELECT vlocity_cmt__OrchestrationQueueId__c queueId, COUNT(Id) cnt
FROM vlocity_cmt__OrchestrationItem__c
WHERE vlocity_cmt__State__c IN ('Ready', 'Failed')
AND vlocity_cmt__OrchestrationItemType__c IN ('Callout', 'AutoTask')
AND vlocity_cmt__OrchestrationQueueId__c in ('a334J000001MQppQAG')
GROUP BY vlocity_cmt__OrchestrationQueueId__c