IO Sort Cost Calculation (2)
Interpreting formulae; comparison to full table scan calculation Continue Reading
Month: July 2019
IO Sort Cost Calculation
IO Sort Cost Calculation: formulae and internals Continue Reading
Extracting Join Order from Optimizer Trace
Programmatically extracting join order information from optimizer trace Continue Reading
Extracting Query Block Information from Optimizer Trace
Programmatically extracting the query block information from the optimizer trace Continue Reading
Scalar Subqueries with OUTER JOIN
Wrong cost calculation when an OUTER JOIN drives the execution of a correlated scalar subquery in SELECT DISTINCT Continue Reading