Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I create my joins on primary/foreign keys that are guids...I don't seem to be able to create an index on this field in my target table. After joining to this table it takes 4 minutes to open the source table.

Can indexes be built on guids fields..if not what work arounds do you guys see? Thanks.

share|improve this question
add comment

1 Answer 1

Yes, a index can be built on it; but you are indexing a long string value so that has some cost but overall you can use that to build a consistent string to join against. Just remember that a GUID by nature is always unique; so if you want to have a many-one relationship then one of your fields will need to be a string since you couldn't have many rows with the same GUID.

share|improve this answer
    
When running the create index tool in ArcMap, that field does not show up as an option. –  Justin Oct 16 '11 at 19:11
    
You need to add it to the layer from ArcCatalog; That should allow you to add it. Not being able to do it from inside ArcMap I think has to do with locking and the schema change. –  D.E.Wright Oct 17 '11 at 15:11
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.