|Re: [firebird-support] Comparing two tables and locate not matched question
|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.