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 have this problem with a simple join and I don't know what to do.

Here's the deal:

  • have a shape file with 400,000 parcels, in this shape I have only one column with the parcel id with an index.

  • I have a Materialized View in Oracle with only 2,000 rows, this view has 4 columns, one of them is the parcel id also with an index.

  • In ArcCatalog I added a new database connection to get the Materialized View.

  • In ArcMap I added the shape file and the materialized view with no problems. Displaying the data of each layer takes less than a second.

  • In ArcMap I create a join by parcel id keeping only matching records.

At this step, when I open the attribute table it takes up to a minute to get the data and drawing the layer also takes a long time. Beacuse of this, I can't use this mxd project at all.

What am I doing wrong? Can anyone help me out?

share|improve this question

1 Answer 1

Generally, join takes time. I don;t have any suggestion to improve the performance.

Hope, you may have tried with file geodatabase, it has better indexing capability and data storage limits and technically it is good to store your 400k polygon data.

share|improve this answer

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.