Activity Forums Salesforce® Discussions What is selective query in Salesforce?

  • Marziya

    Member
    April 17, 2020 at 12:44 pm

    Hii Ayush,
    Search Results
    Featured snippet from the web
    Selective SOQL Query Criteria. A query is selective when one of the query filters is on an indexed field and the query filter reduces the resulting number of rows below a system-defined threshold. The performance of the SOQL query improves when two or more filters used in the WHERE clause meet the mentioned conditions.

  • Anjali

    Member
    April 17, 2020 at 1:15 pm

    A query is selective when one of the query filters is on an indexed field and the query filter reduces the resulting number of rows below a system-defined threshold.

  • Manish

    Member
    April 17, 2020 at 2:01 pm

    Selective SOQL Query Criteria. A query is selective when one of the query filters is on an indexed field and the query filter reduces the resulting number of rows below a system-defined threshold. The performance of the SOQL query improves when two or more filters used in the WHERE clause meet the mentioned conditions.

  • Pooja

    Member
    April 17, 2020 at 2:15 pm

    query is selective when one of the query filters is on an indexed field and the query filter reduces the resulting number of rows below a system-defined threshold.

Log In to reply.

Popular Salesforce Blogs