[dba-SQLServer] How would you cross index

Stuart McLachlan stuart at lexacorp.com.pg
Fri Jun 4 17:44:09 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-SQLServer mailing list