Let’s look at the code JOIN MERGEJOIN (inputs presorted) [Cost: 750, Rows: 1200] (PATH ID: 1). What does the number 750 represent?

Hi @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