Question
Let’s look at the code JOIN MERGEJOIN (inputs presorted) [Cost: 750, Rows: 1200] (PATH ID: 1). What does the number 750 represent?
Let’s look at the code JOIN MERGEJOIN (inputs presorted) [Cost: 750, Rows: 1200] (PATH ID: 1). What does the number 750 represent?
+14Hi @sivarani.tarra,
The number 750 represents the estimated cost (resources) of the join operation in this case. The lower the number, the more efficient the operation.
You think of resources such as CPU & Memory.
Kind regards,
Sverre Klein
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.