Cost-Based Join Reorder: In this phase, the optimizer enumerates a large number of candidate join plans and computes the cost with the help of the cardinality estimation and cost model to obtain the best join order. PostgreSQL uses a DPsize algorithm with System-R style, while MySQL uses a...