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.

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
    
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
    
fGDB is ESRIs' own database format, there is an API that will allow you to access data without ESRI objects but I doubt that would shed much light on your quandry. The use of indicies is automatic and can't be detected or affirmed. I agree with blah238 that's the only way to tell for sure. The 'unique' and 'ascending' options can have a big difference but only use these options if you are absolutely certain of uniqueness and/or ascention. –  Michael Miles-Stimson Oct 9 '13 at 22:05

This site is currently not accepting new answers.

Browse other questions tagged .