Please let me know which is the better way to select the rows
T1
SNo C1 C2 C3
1 001 NULL NULL
2 NULL 02 NULL
3 NULL NULL 03
4 004 NULL NULL
Other columns in T1 are not shown here
T2
SNo C1 C2 C3
1 001 NULL NULL
2 NULL 02 NULL
Other columns in T2 are not shown here
The records which are in T1 and not in T2 needs to be in T2.
In this e.g., Sno 3 and 4.
Is it better to go for MINUS and select those rows from T1 or should I do induvidual colmn level comparison against both the tables and arrive at the resulting rows. Which is the better way, also which is better for performance ?