Activity Forums Salesforce® Discussions When Salesforce will use Custom Indexed fields?

  • shariq

    Member
    September 22, 2018 at 6:13 pm

    Salesforce maintains statistics table which stores information about records present in Organization. If records going to be searched is less than or equal to 10% of total records or up to 333,333 records then only it makes sense to use standard Indexed fields to narrow result else total records going to be returned is more than 10% already so Salesforce will not use any indexing.

  • Parul

    Member
    September 23, 2018 at 6:14 am

    To create custom indexes for other field types, including standard fields, contact salesforce.com Customer Support

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos