Posts Tagged ‘key distributions’

The battle between FORCE INDEX and the QUERY OPTIMIZER




Query Optimizer is a part of the server that takes a parsed SQL query and produces a query execution plan. MySQL Query Optimizer uses (as one of its parameters) the stored key distribution (Cardinality) mechanism to determine the order in which tables should be joined, when you perform a join on something other than a […]