SELECT PIV.* FROM CNF.F_VORDERING_PIVOT PIV JOIN ETL.F_VORDERING_PIVOT_NEW N ON PIV.KOPPEL_ID_VOR_VER = N.KOPPEL_ID_VOR_VER where PIV.DWH_VALID_TO_DT = '9999-12-31'

QUERY PLANTEXT:

Hash Join (cost=54057.1..54324.8 rows=3459 width=664 conf=51)
   l: Sequential Scan table "N" (cost=0.0..139.5 rows=314541 width=21 conf=100)
   r: Hash (cost=54057.1..54057.1 rows=3182 width=664 conf=0)
      l: Sequential Scan table "PIV" (cost=0.0..54057.1 rows=3182 width=664 conf=64)


SELECT PIV.* FROM CNF.F_VORDERING_PIVOT PIV JOIN ETL.F_VORDERING_PIVOT_NEW N ON PIV.KOPPEL_ID_VOR_VER = N.KOPPEL_ID_VOR_VER

QUERY PLANTEXT:

Hash Join (cost=139.5..54196.7 rows=20922206 width=664 conf=64)
   l: Sequential Scan table "PIV" (cost=0.0..54057.1 rows=156875138 width=664 conf=80) (FACT)
   r: Hash (cost=139.5..139.5 rows=314541 width=21 conf=0)
      l: Sequential Scan table "N" (cost=0.0..139.5 rows=314541 width=21 conf=100)