using 'not in'

Operation	Object Name			Rows	Bytes	Cost		Object Node	In/Out	PStart	PStop

INSERT STATEMENT Optimizer Mode=ALL_ROWS	138 M	 	44036 G	 	      	             	 
  FILTER		  	 	 	 	      	             	 
    TABLE ACCESS FULL	schema.tableA		138 M	11G	409715  	 	      	             	 
    INDEX FULL SCAN	schema.tableB_index	1  	10  	318698  	 	      	             	 



using 'minus'

Operation	Object Name				Rows	Bytes	Cost	Object Node	In/Out	PStart	PStop

INSERT STATEMENT Optimizer Mode=ALL_ROWS		138 M	 	7232064  	 	      	             	 
  MINUS		  	 	 	 	      	             	 
    SORT UNIQUE						138 M	11G	3319224  	 	      	             	 
      TABLE ACCESS FULL	schema.tableA			138 M	11G	409526  	 	      	             	 
    SORT UNIQUE						114 M	10G	3912840  	 	      	             	 
      HASH JOIN						114 M	10G	1274343  	 	      	             	 
        INDEX FAST FULL SCAN	schema.tableB_index	113 M	1G	70344  	 	      	             	 
        TABLE ACCESS FULL	schema.tableA		138 M	11G	409526