• #20010
    Salesforce | Saurabh Saurabh #131
    Forcetalks

    Explain some functionality of Force.com Query Optimizer in salesforce?

    Explain some functionality of Force.com Query Optimizer in salesforce?

    #20025
    Salesforce | Manpreet Manpreet #228
    Forcetalks

    Hi saurabh,

    The Force.com query optimizer:

    # Determines the best index from which to drive the query, if possible, based on filters in the query
    # Determines the best table to drive the query from if no good index is available
    # Determines how to order the remaining tables to minimize cost
    # Injects custom foreign key value tables as needed to create efficient join paths
    # Influences the execution plan for the remaining joins, including sharing joins, to minimize database input/output (I/O)
    # Updates statistics.

    Thanks.

Viewing 2 posts - 1 through 2 (of 2 total)

Please to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2019 Forcetalks. All Right Reserved.

Log in with your credentials

or    

Forgot your details?