Hi Community,

When join operator is used in GQI query and the amount of data is considerable big, is it important to think about the size of table (number of row) manipulated by the join action or to reduce the number of operator (select, filter)

Attached screenshot showing 2 implementations giving the same result:

1. many select operator used to reduce the number of columns sent to 'join' operator which will decrease the outcome data size.
2. All the data sent to 'join' operator without filtration to decrease the number of processing action

Please for your recommendation for such case.

Thank you in advance