Interview question
- From: rajugaru.vij@xxxxxxxxx
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Fri, 26 Apr 2013 13:36:32 +0000
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--
//www.freelists.org/webpage/oracle-l
Other related posts:
