Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop DELETE STATEMENT Optimizer Mode=ALL_ROWS 150 M 608284 DELETE schema.tableA MERGE JOIN ANTI 150 M 2G 608284 INDEX FULL SCAN schema.uniqueid_indexA 194 M 2G 431349 SORT UNIQUE 44 M 293 M 176935 INDEX FAST FULL SCAN schema.uniqueid_indexB 44 M 293 M 23839