Subject Re: [firebird-support] Comparing two tables and locate not matched question
Author Andrew Jeremy Gargan
What do your indexes look like?
What size record sets are we talking about?
What is a long time?

On Tue, Mar 18, 2014 at 5:19 PM, <jim.rhema316@...> wrote:

Good day,

I am seeking advice on the best way to locate a record that is in one table and not another.

I currently have two tables. Vendor_Products which contains all the products for a vendor and Active_Inventory which contains products that are available as of the last update.  I want to search the Vendor_Products table using a field (product_ID) from Active_Inventory and locate data that doesn't exist in the  exists in the Vendor_Products but doesn't exist in the Active_Inventory  table.  Once I find a not found condition in the Vendor_Products table I want to output data to the Active_Inventory.

I am trying a merge with the matched and not matched but it is taking a very long time to process.

Any suggestions?

Thank you very much.



Andrew Gargan