SQL: Inner joining two massive tables
I’m not an SQL tuning expert, but joining hundreds of millions of rows on a VARCHAR field doesn’t sound like a good idea in any database system I know. You could try adding an integer column to each table and computing a hash on the NAME field that should get the possible matches to a … Read more