Skip to main content
Question

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 estim

  • July 19, 2023
  • 1 reply
  • 2 views

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

1 reply

Forum|alt.badge.img+3
  • Celonaut
  • February 8, 2024

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