Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 4 down vote favorite

We have some software as part of a larger project written using ArcObjects via .NET. This software migrates and merges data from multiple file geodatabases in one schema to a single file geodatabase in a similar but different schema. Some steps in the migration involve looking up an existing row and updating it with data from a different table. This can get very slow when the destination geodatabase is large, so I have added some multi-field attribute indexes to improve the query/update performance.

Is there a way that I can confirm that the queries are using the new attribute indexes, and perhaps how the query is being executed?

I guess I'm really looking for the equivalent of a query plan - something similar to EXPLAIN PLAN in Oracle.

The queries are on a file geodatabase using ArcObjects directly (no RDBMS backend or SQL).

share|improve this question
Have you timed the performance with and without attribute indexes? I think that's the only way to know that they're having an effect. – blah238 Nov 5 '12 at 5:01
I'm running performance tests now with various sizes of dataset. I'll try to post results when I get them. – Gnat Nov 5 '12 at 5:12
I looked in the ArcObjects class libraries for something similar to Smallworld Magik's is_size_fast? method, which returns true if indexes are being used, but I couldn't see an equivalent ArcObjects call. – Gnat Nov 5 '12 at 10:20

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.