Toggle Side Panel
Close search

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.

  • [adinserter block='9']

  • 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.