stuart at lexacorp.com.pg
Fri Jun 4 17:39:55 CDT 2010
At first glance, that's the way I would handle it too. One advantage is that once you have updated the master table, you can drop all the name/address columns from the data tables and save quite a bit of space :-) -- Stuart On 4 Jun 2010 at 17:18, jwcolby wrote: > What method would you use to allow a cross index? > > The only method that I am coming up with would be to have a name/Address table with additional > fields to store the PKID from each table. Add each unique name / address into the table one time. > Use the name hash in inner joins to discover exact matches. Update the PKID fields in each column > for the table(s) that the match(es) occur. Add a new column every time you get a new table.
More information about the dba-VB mailing list