Compare two very large tables
So im looking to compare two very large tables.
TableA + TableB
TableA is the table used by the site, and TableB is imported data.
I want to compare the two, and if a row is found in TableA, that matches a row in TableB, I want to delete it (from TableA)
Anyone got any ideas?
But it's important that the two keys shown in that query are each an index on their respective tables. Else the query will run really slowly.
|All times are GMT +1. The time now is 02:07 AM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.