GIS Tip: Joining Large Shapefiles
If you are joining a very large shapefile on an attribute field, it is much faster to join the dbfs and calculate new fields in Microsoft Access.
Then just overwrite the dbf part of the shapefile with the new improved dbf.
Technorati Tags: GIS, shapefile, join, tips