Doing a row-by-row data compare of a very large table with an added where clause that returns about 1000 rows. When I add a key column, Toad is querying the ENTIRE table to determine uniqueness. It should use the Where clause for uniqueness check.
Thanks Dale. I see that too and will fix.
workaround: create a view that includes the where clause, then compare the views.
Fixed for when we start betas again