Toad World® Forums

data compare specifying key issue

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