Interview question

From: <rajugaru.vij_at_gmail.com>
Date: Fri, 26 Apr 2013 13:36:32 +0000
Message-ID: 873574598-1366983384-cardhu_decombobulator_blackberry.rim.net-1425796298-_at_b28.c12.bise7.blackberry>

Again back with an interview question.
Table A has 400 million rows and table b has 1 million rows.

I want to compare table A and Table B and find all the rows available in b which are already available in A.

want to remove all those which are available in B from A.

What would be best option? Deleting them or adding a column and flagging them?

What's the better option performance wise?

Thanks
Sent on my BlackBerry® from Vodafone--
http://www.freelists.org/webpage/oracle-l Received on Fri Apr 26 2013 - 15:36:32 CEST