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

  • Jul 19, 2023 4:59 PM UTC
  • 1 reply
  • 95 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
  • Feb 8, 2024 9:52 AM UTC

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