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).