How to Index a custom field or ensure it is Primary Key?

Forum|Forum|6 years ago
November 7, 2019
2 replies
3516 views

How can I ensure to have an index on a custom field and make it Primary? My Lookup field is a custom field, will that be as efficient as any other custom field I create or we have to someway create an index on this field?

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

SanfordWhiteman

Level 10

You can't manually index a field. If it's eligible for lookup then it's as efficient as any other.

Vishwa_KumarAuthor

Level 2

What makes a custom field eligible for lookup?

FYI - on my Sandbox environment I am able to send the lead data using this custom field as lookup.

SanfordWhiteman

Level 10

Any custom String, Email, or Integer field is eligible AFAIK. Note it would never be the primary key anyway, you could be thinking about a unique key (which it's not) but in any case the indexing isn't under user control.

Vishwa_KumarAuthor

Level 2

Ok, so just want to be clear, since right now I am only pushing some test data, using a custom field of data type integer as lookup field. It seems to be working fine. But will it be a potential issue when volumes of data will be pushed later, and if there is no indexing or uniqueness on this key, it might slow down or cause any issue?

If there are chances of any issue, what would be recommended solution?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded