Re: efficient compare

Opps! And some products will accept "TABLE A EXCEPT TABLE B", but I like "SELECT * FROM ." a bit better.

To answer Bob's question about physical implementation and efficiency, that would vary from product to product. However, I think that DB2 turns the whole row into a long bit string to do the matching, so it runs really fast. Years ago, I found that the Oracle MINUS operator was the fastest way to do a relational division. Received on Fri Apr 21 2006 - 17:49:37 CDT