Skip to main content
Let's look at the code JOIN MERGEJOIN (inputs presorted) [Cost: 750, Rows: 1200] (PATH ID:1). What does the number 750 represent? A. The total cost of sales items in this joined dataset The exact known cost of the query runtime C. The estimation cost

The cost number in an EXPLAIN query is arbitrary. It allows you to compare different parts a query to identify the most computationally intensive.


Reply