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, <[email protected]> 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. > > Jim > > > -- Regards Andrew Gargan
