Join takes too long?

Discussion created by bschwarz on Jan 13, 2013
Latest reply on Jan 14, 2013 by bschwarz
I've been using ESRI products since ARC/INFO 3. 

I recall being able to perform a join or setup relationships between tables using different techniques.  For example indicating the data in the related column is sorted and thus you could use the ORDERED option.  This naturally sped up the join or relate a great deal.

I'm using the following python code...

arcpy.JoinField_management(pointFC, "joinfld_name", pointattributes, "joinfld_name")

to join a table of 200,000 records to a point FC of exactly the same number of records (i.e. 1:1 match).

This join takes more than 25 minutes.  I suspect it takes so long because it's not performing any intelligent searching on the join column of the "pointAttributes" table.  Instead it's just doing a brute force search.

I've tried creating an attribute index on both columns but this didn't seem to help.

All of the data is in the same fGDB.

I'm running Windows 7 with ARcGIS 10.0 on a relatively new laptop. 

Thanks for any help.

Regards, Brian