Required Indexes for Industries CPQ Implementations

If you are implementing Industries CPQ, add the following required indexes to support the related CPQ objects.

Note

Salesforce does not allow installation of custom indexes in an org during install. 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.

If you are implementing Industries CPQ, you must add the following required indexes to support the related CPQ objects.

CPQ Objects	Required Indexes
Opportunity-Based CPQ	OpportunityLineItem.vlocity_cmt__ParentItemId__c OpportunityLineItem.vlocity_cmt__RootItemId__c
Order-Based CPQ	OrderItem.vlocity_cmt__ParentItemId__c OrderItem.vlocity_cmt__RootItemId__c OrderItem.vlocity_cmt__AssetReferenceId__c
Quote-Based CPQ	QuoteLineItem.vlocity_cmt__ParentItemId__c QuoteLineItem.vlocity_cmt__RootItemId__c QuoteLineItem.vlocity_cmt__AssetReferenceId__c
Contract and Asset-Based Operations	Asset.vlocity_cmt__ParentItemId__c Asset.vlocity_cmt__RootItemId__c Asset.vlocity_cmt__AssetReferenceId__c Asset.vlocity_cmt__PricebookEntryId__c vlocity_cmt__ContractLineItem__c.vlocity_cmt__AssetReferenceId__c vlocity_cmt__ContractLineItem__c.vlocity_cmt__PricebookEntryId__c

Sample SOQL Queries Requiring Custom Indexes

The following sample SOQL queries require custom indexes. You may need to update the ID values in the WHERE clauses so that they refer to an actual record in your Salesforce org.

Optional Indexes for CPQ Implementation

For better performance, we recommend indexing the vlocity_cmt__SubClassId__c field for the object vlocity_cmt__ObjectFieldAttribute__c.

Asset SOQL Queries

Asset.vlocity_cmt__ParentItemId__c

SELECT Id,ParentId,vlocity_cmt__AssetReferenceId__c,vlocity_cmt__ParentItemId__c,vlocity_cmt__PricebookEntryId__c,vlocity_cmt__RootItemId__c FROM Asset WHERE vlocity_cmt__ParentItemId__c = '02i3i00000099TNAAY'

Asset.vlocity_cmt__RootItemId__c

SELECT Id,ParentId,vlocity_cmt__AssetReferenceId__c,vlocity_cmt__RootItemId__c FROM Asset WHERE vlocity_cmt__RootItemId__c = '02i3i00000099TaAAI'

Asset.vlocity_cmt__AssetReferenceId__c

SELECT Id,ParentId,vlocity_cmt__AssetReferenceId__c FROM Asset WHERE vlocity_cmt__AssetReferenceId__c = 'f49e9fa7-2f95-814f-084a-bc017de032ff'

Asset.vlocity_cmt__PricebookEntryId__c

SELECT Id,ParentId,vlocity_cmt__AssetReferenceId__c,vlocity_cmt__PricebookEntryId__c,vlocity_cmt__RootItemId__c FROM Asset WHERE vlocity_cmt__PricebookEntryId__c = '01u3i000000PavqAAC'

Order Item SOQL Queries

OrderItem.vlocity_cmt__ParentItemId__c

SELECT Id,OrderId,vlocity_cmt__ParentItemId__c FROM OrderItem WHERE vlocity_cmt__ParentItemId__c = '8023i0000000EBkAAM'

OrderItem.vlocity_cmt__RootItemId__c

SELECT Id,OrderId,vlocity_cmt__ParentItemId__c,vlocity_cmt__RootItemId__c FROM OrderItem WHERE vlocity_cmt__RootItemId__c = '8023i0000000EBkAAM'

OrderItem.vlocity_cmt__AssetReferenceId__c

SELECT Id,OrderId,vlocity_cmt__AssetReferenceId__c,vlocity_cmt__ParentItemId__c,vlocity_cmt__RootItemId__c FROM OrderItem WHERE vlocity_cmt__AssetReferenceId__c = 'f8c87dd8-42bd-acce-c064-0ff505aa0883'