Questions tagged [custom-index]
Custom indexes create a non-clustered index on one attribute (single index) or on a list of attributes (composite index), in an entity. Generally indexes improve the performance of querying process.
25
questions
0
votes
1
answer
39
views
Packaged CustomIndex and unpackaged custom indexes on the same field; will this prevent a package upgrade?
We have an AppExchange listed package. This includes an object with a Datetime field that is really important in various queries. Several of our larger customers have had to have custom indexes added ...
- 34.2k
0
votes
1
answer
38
views
What are examples of performance degredation which *don't* get posted on trust.salesforce.com?
My org had a temporary performance degredation with regards to a custom index on a particular field in a custom object 2 months ago. This was confirmed in writing by Salesforce Support in the ticket ...
- 3,632
0
votes
1
answer
93
views
Project with custom indexes fails on package build command
Writing an app to publish on the AppExchange, and this app contains some text fields that have a uniqueness constraint on them. As per the Salesforce documentation, when that constraint is applied the ...
- 12.7k
5
votes
2
answers
1k
views
How do custom indexes impact performance negatively?
I am trying to understand the negative tradeoffs in creating more custom indexes on an sObject. Yes, they are helpful with query selectivity which speeds up reading data, but at what price. ...
- 10.5k
1
vote
0
answers
53
views
Can you index the isDeleted field? If so, how do you calculate the selectivity threshold
Can you index the standard isDeleted field? If so, in terms of calculating the selectivity threshold, would it be considered a unary standard or unary custom index?
I'm working with large data volumes ...
- 10.5k
5
votes
3
answers
3k
views
Property 'allowNullValues' not valid in version 54.0
When using force:source:deploy with a package.xml we have the following error
Error Contract__c.ContractNumber__c Property 'allowNullValues' not valid in version 55.0
Everything was fine until ...
- 3,130
12
votes
1
answer
1k
views
Create custom Index via Metadata API now possible?
While doing prodsync today I stumbled upon a folder named as customIndex. Funnily enough it had all custom indexes that we had asked SF to create for us. Once downloaded, I tried to save this in my ...
- 35.8k
3
votes
0
answers
172
views
How to add a new field with a custom index to a managed package
Our managed package is adding a brand new custom field that is marked as external id and therefore has a custom index associated to it. Through Salesforce's UI we can add a Custom Index component type ...
- 302
0
votes
1
answer
475
views
Custom Indexes of Null Records
I'm reading up on Custom Indexes and the documentation says:
By default, the index tables do not include records that are null (records with empty values). You can work with Salesforce Customer ...
0
votes
1
answer
917
views
Can we create an indexed field which is not unique
I am extremely new to salesforce. I read that we can mark any custom field as an ExternalID which creates an index over it. I have a use-case where I have multiple Address records which have the same ...
- 111
0
votes
1
answer
247
views
Integration between Cookiebot and SalesForceMarketingCloud
In my client we try to connect Marketing Cloud with Cookiebot. Cookiebot is a site that collects and stores cookies for each landing page. For this to be possible, we must create an index of all our ...
- 1
0
votes
1
answer
588
views
Is there anything we need to check before mark a text field as External Id?
Do we need to check anything in a running org before making a text field as an External Id to avoid Non-selective query against large object type Exception? (Data loss, any apex errors, etc)
I have ...
- 582
1
vote
1
answer
92
views
Way to provide complex unique restriction
Let's say we have custom object with 2 key fields. How can I provide complex unique index to avoid interactive inserting records with the same values in this fields?
- 839
2
votes
0
answers
146
views
How to create an index for already released field in managed package to automatically propagate it to all subscribers on upgrade
We are receiving bunch of errors from subscribers' orgs where our managed package is installed:
"System.QueryException: Non-selective query against large object type"
After conducting our local ...
- 2,990
3
votes
1
answer
284
views
Are Custom Indexes passed on to Sandboxes
Are "Customer Support Enabled" custom indexes also pulled into Sandboxes? I cannot find documentation about this.
Note: I am NOT asking about user-defined custom indexes.
- 2,191
2
votes
0
answers
174
views
Can Lookup Field be part of Composite Index?
I have an sObject say
student( ..., student_name text,favourite_teacher
lookup,marks integer)
By the documentation , lookup fields (favourite_teacher) will be indexed by default.
Is it possible ...
- 123
-2
votes
1
answer
637
views
RenderAs='PDF' Index in the Visual Force Component/Page [closed]
I'm trying to create a Visualforce Component with the renderAs="PDF" and I'm stuck on the issue with the auto-number/index.
Is there a way to create the auto-number and a index page on the VF Page or ...
- 3
1
vote
1
answer
57
views
Is this a selective SOQL?
Select Id, Field1_Id__c, Field2__c from CustomObject__c where Field1_Id__c =: STRING_CHARACTER_BLANK AND Field2__c IN: setOfIds
Getting the following error when a query as above is executed from a ...
- 189
0
votes
0
answers
133
views
Restrictions with HomePhone ( i.e Standard field ) for indexing?
I am working on a requirement where I need to use phone fields in where clause of the apex code, and I need those fields to be indexed. I contacted support to request they index a set fields, and they ...
- 512
0
votes
2
answers
2k
views
Limits on number of fields to be indexed for Salesforce Big Objects
Does Salesforce have any limits on indexing the number of fields on a Big Object?
The example in the latest Big Object guide indexes 3 fields. Does anyone know, whats the governor limit on number of ...
- 67
9
votes
1
answer
7k
views
What makes a formula field non-deterministic and hence not available for a custom index?
The Knowledge Article: 000006007 - Custom indexes for an organization to help improve performance lists the following in relations to indexes on formula fields:
Note:
Formula field can also be ...
- 102k
2
votes
1
answer
2k
views
Can I create an index on a field to speed up searching?
I have a large table (10's of millions of records), I want to be able to filter reasonable quickly, can I create an index on a field to help speed up fitlering?
- 5,237
3
votes
1
answer
213
views
Customer Portal and SOQL query optimization
We have a customer portal which has sharing set by Account i.e. Record level security by granting access to portal users where their Account matches the Account associated with the record.
I was ...
- 1,722
4
votes
2
answers
1k
views
Query Plan tool in Developer Console showing index plan for custom field which is not indexed
I am trying to evaluate some of our SOQL queries using query plan tool in Developer Console.
Query is on custom object and we don't have any custom index on any of the custom field of this object.
...
- 1,722
6
votes
2
answers
4k
views
How can I find out what custom indexes have been created in my Org?
In orgs with large data volumes, it sometimes becomes necessary to ask Salesforce to create a custom index on a particular field, or combination of fields.
Once Salesforce creates a custom index, is ...
- 5,693