- May 5, 2017 at 1:51 pm #20010Saurabh #131
Explain some functionality of Force.com Query Optimizer in salesforce?
Explain some functionality of Force.com Query Optimizer in salesforce?May 8, 2017 at 12:58 pm #20025Manpreet #228
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.
Please Register to reply to this topic. /