ProjectNode
  + Output Columns:SUPPLIER_ID (string)
  + Statistics:
    0: Node Output Rows: 16
    1: Node Process Time: 0
    2: Node Cumulative Process Time: 192
    3: Node Cumulative Next Batch Process Time: 18
    4: Node Next Batch Calls: 5
    5: Node Blocks: 4
  + Cost Estimates:Estimated Node Cardinality: -1.0
  + Child 0:
    PlanExecutionNode
      + Output Columns:SUPPLIER_ID (string)
      + Statistics:
        0: Node Output Rows: 16
        1: Node Process Time: 192
        2: Node Cumulative Process Time: 192
        3: Node Cumulative Next Batch Process Time: 18
        4: Node Next Batch Calls: 5
        5: Node Blocks: 4
      + Cost Estimates:Estimated Node Cardinality: -1.0
      + Execution Plan:
        Program
          + Instruction 0:
            ASSIGNMENT
              + Variable:x
          + Instruction 1:
            CREATE CURSOR
              + Result Set:EXECSQL_INSTRUCTION
              + Query:
                ProjectIntoNode
                  + Output Columns:Count (integer)
                  + Statistics:
                    0: Node Output Rows: 1
                    1: Node Process Time: 4
                    2: Node Cumulative Process Time: 101
                    3: Node Cumulative Next Batch Process Time: 8
                    4: Node Next Batch Calls: 3
                    5: Node Blocks: 2
                  + Cost Estimates:Estimated Node Cardinality: 59.540985
                  + Child 0:
                    ProjectNode
                      + Output Columns:SUPPLIER_ID (string)
                      + Statistics:
                        0: Node Output Rows: 227
                        1: Node Process Time: 0
                        2: Node Cumulative Process Time: 97
                        3: Node Cumulative Next Batch Process Time: 4
                        4: Node Next Batch Calls: 3
                        5: Node Blocks: 2
                      + Cost Estimates:Estimated Node Cardinality: 59.540985
                      + Child 0:
                        JoinNode
                          + Output Columns:SUPPLIER_ID (string)
                          + Statistics:
                            0: Node Output Rows: 227
                            1: Node Process Time: 47
                            2: Node Cumulative Process Time: 97
                            3: Node Cumulative Next Batch Process Time: 4
                            4: Node Next Batch Calls: 3
                            5: Node Blocks: 2
                          + Cost Estimates:Estimated Node Cardinality: 59.540985
                          + Child 0:
                            AccessNode
                              + Output Columns:SUPPLIER_ID (string)
                              + Statistics:
                                0: Node Output Rows: 16
                                1: Node Process Time: 44
                                2: Node Cumulative Process Time: 44
                                3: Node Cumulative Next Batch Process Time: 1
                                4: Node Next Batch Calls: 2
                                5: Node Blocks: 1
                              + Cost Estimates:Estimated Node Cardinality: 16.0
                              + Query:SELECT g_0.SUPPLIER_ID AS c_0 FROM PartsSourceB.SUPPLIER AS g_0 ORDER BY c_0
                              + Model Name:PartsSourceB
                          + Child 1:
                            AccessNode
                              + Output Columns:SUPPLIER_ID (string)
                              + Statistics:
                                0: Node Output Rows: 227
                                1: Node Process Time: 50
                                2: Node Cumulative Process Time: 50
                                3: Node Cumulative Next Batch Process Time: 0
                                4: Node Next Batch Calls: 2
                                5: Node Blocks: 1
                              + Cost Estimates:Estimated Node Cardinality: 227.0
                              + Query:SELECT g_0.SUPPLIER_ID AS c_0 FROM PartsSourceA.SUPPLIER_PARTS AS g_0 ORDER BY c_0 NULLS FIRST
                              + Model Name:PartsSourceA
                          + Join Strategy:MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)
                          + Join Type:INNER JOIN
                          + Join Criteria:PartsSourceB.SUPPLIER.SUPPLIER_ID=PartsSourceA.SUPPLIER_PARTS.SUPPLIER_ID
                      + Select Columns:PartsSourceA.SUPPLIER_PARTS.SUPPLIER_ID
                  + Into Target:#tempSupplierInfo
                  + Select Columns:#tempSupplierInfo.SUPPLIER_ID
          + Instruction 2:
            LOOP
              + Query:
                AccessNode
                  + Output Columns:SUPPLIER_ID (string)
                  + Statistics:
                    0: Node Output Rows: 227
                    1: Node Process Time: 0
                    2: Node Cumulative Process Time: 0
                    3: Node Cumulative Next Batch Process Time: 0
                    4: Node Next Batch Calls: 1
                    5: Node Blocks: 0
                  + Cost Estimates:Estimated Node Cardinality: -1.0
                  + Query:SELECT #tempSupplierInfo.supplier_id FROM #tempSupplierInfo
                  + Model Name:__TEMP__
              + Result Set:supplier_idCursor
              + Program:
                Program
                  + Instruction 0:
                    ASSIGNMENT
                      + Variable:x
                      + Expression:supplier_idCursor.supplier_id
          + Instruction 3:
            CREATE CURSOR
              + Result Set:EXECSQL_INSTRUCTION
              + Query:
                ProjectNode
                  + Output Columns:SUPPLIER_ID (string)
                  + Statistics:
                    0: Node Output Rows: 16
                    1: Node Process Time: 0
                    2: Node Cumulative Process Time: 82
                    3: Node Cumulative Next Batch Process Time: 1
                    4: Node Next Batch Calls: 3
                    5: Node Blocks: 2
                  + Cost Estimates:Estimated Node Cardinality: 28.375
                  + Child 0:
                    JoinNode
                      + Output Columns:SUPPLIER_ID (string)
                      + Statistics:
                        0: Node Output Rows: 16
                        1: Node Process Time: 40
                        2: Node Cumulative Process Time: 82
                        3: Node Cumulative Next Batch Process Time: 1
                        4: Node Next Batch Calls: 3
                        5: Node Blocks: 2
                      + Cost Estimates:Estimated Node Cardinality: 28.375
                      + Child 0:
                        AccessNode
                          + Output Columns
                          + Statistics:
                            0: Node Output Rows: 1
                            1: Node Process Time: 40
                            2: Node Cumulative Process Time: 40
                            3: Node Cumulative Next Batch Process Time: 0
                            4: Node Next Batch Calls: 2
                            5: Node Blocks: 1
                          + Cost Estimates:Estimated Node Cardinality: 1.0
                          + Query:SELECT 1 FROM PartsSourceB.SUPPLIER AS g_0 WHERE (g_0.SUPPLIER_ID = VARIABLES.x) AND (VARIABLES.x = VARIABLES.x)
                          + Model Name:PartsSourceB
                      + Child 1:
                        AccessNode
                          + Output Columns:SUPPLIER_ID (string)
                          + Statistics:
                            0: Node Output Rows: 16
                            1: Node Process Time: 42
                            2: Node Cumulative Process Time: 42
                            3: Node Cumulative Next Batch Process Time: 1
                            4: Node Next Batch Calls: 2
                            5: Node Blocks: 1
                          + Cost Estimates:Estimated Node Cardinality: 28.375
                          + Query:SELECT g_0.SUPPLIER_ID FROM PartsSourceA.SUPPLIER_PARTS AS g_0 WHERE (g_0.SUPPLIER_ID = VARIABLES.x) AND (VARIABLES.x = VARIABLES.x)
                          + Model Name:PartsSourceA
                      + Join Strategy:NESTED LOOP JOIN
                      + Join Type:CROSS JOIN
                      + Join Criteria
                  + Select Columns:SUPPLIER_PARTS__1.SUPPLIER_ID
          + Output Columns:SUPPLIER_ID (string)
  + Select Columns:PartsVirtual.MMSP07.SUPPLIER_ID