topic Re: attribute indexes in distributed data in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/attribute-indexes-in-distributed-data/m-p/795639#M2358 <HTML><HEAD></HEAD><BODY><P>No they shouldn't cause any issues.Mainly it just speeds up the querying process, without altering the schema or data.</P><P></P><P>However, recommendation is to always test on a small subset of data before implementing in production environment.</P></BODY></HTML> Tue, 03 Oct 2017 16:47:28 GMT Asrujit_SenGupta 2017-10-03T16:47:28Z attribute indexes in distributed data https://community.esri.com/t5/geodatabase-questions/attribute-indexes-in-distributed-data/m-p/795638#M2357 <HTML><HEAD></HEAD><BODY><P>Our master geodatabase, on SQL Server, contains data layers that&nbsp; are maintained on a separate file geodatabase, and are replicated on the master database.&nbsp; We would like to create attribute indexes on those layers in our master geodatabase.&nbsp; The question is, will synchronization and replication break or cause problems with those attribute indexes when the data updates are pushed from the file geodatabase?</P></BODY></HTML> Tue, 03 Oct 2017 16:00:51 GMT https://community.esri.com/t5/geodatabase-questions/attribute-indexes-in-distributed-data/m-p/795638#M2357 BobBistrais 2017-10-03T16:00:51Z Re: attribute indexes in distributed data https://community.esri.com/t5/geodatabase-questions/attribute-indexes-in-distributed-data/m-p/795639#M2358 <HTML><HEAD></HEAD><BODY><P>No they shouldn't cause any issues.Mainly it just speeds up the querying process, without altering the schema or data.</P><P></P><P>However, recommendation is to always test on a small subset of data before implementing in production environment.</P></BODY></HTML> Tue, 03 Oct 2017 16:47:28 GMT https://community.esri.com/t5/geodatabase-questions/attribute-indexes-in-distributed-data/m-p/795639#M2358 Asrujit_SenGupta 2017-10-03T16:47:28Z Re: attribute indexes in distributed data https://community.esri.com/t5/geodatabase-questions/attribute-indexes-in-distributed-data/m-p/795640#M2359 <HTML><HEAD></HEAD><BODY><P>Hi Bob,</P><P></P><P>You should be fine having attribute indexes in your master geodatabase and&nbsp;using replication with your file geodatabases. The help docs for&nbsp;<A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/geodatabases/importing-a-replica-schema.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/geodatabases/importing-a-replica-schema.htm">Importing a replica schema—ArcGIS Help | ArcGIS Desktop</A>&nbsp;indicate that attribute indexes are ignored during schema comparison:</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><SPAN style="color: #4d4d4d; background-color: #fefefe;">Some changes can be applied to individual replica geodatabases but have no effect on data synchronization. For example, adding or removing an attribute index is not detected or even synchronized during schema synchronization. A replica may have indexes that the relative replica doesn't have, but since data synchronization is not affected, this difference is ignored.</SPAN></BLOCKQUOTE><P></P><P>It's probably a good idea to use the Rebuild Indexes tool after synchronizing your replicas for performance reasons. See&nbsp;<A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/geodatabases/rebuilding-dataset-indexes.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/geodatabases/rebuilding-dataset-indexes.htm">Rebuild dataset indexes using the Rebuild Indexes tool—ArcGIS Help | ArcGIS Desktop</A>.</P><P></P><P>Happy replicating/syncing!</P><P></P><P>Micah</P></BODY></HTML> Tue, 03 Oct 2017 16:58:01 GMT https://community.esri.com/t5/geodatabase-questions/attribute-indexes-in-distributed-data/m-p/795640#M2359 MicahBabinski 2017-10-03T16:58:01Z Re: attribute indexes in distributed data https://community.esri.com/t5/geodatabase-questions/attribute-indexes-in-distributed-data/m-p/795641#M2360 <HTML><HEAD></HEAD><BODY><P>Thank you both.&nbsp; I have created an attribute index on the data, we'll monitor and see how it works when the data is synched next time.</P></BODY></HTML> Wed, 04 Oct 2017 20:27:40 GMT https://community.esri.com/t5/geodatabase-questions/attribute-indexes-in-distributed-data/m-p/795641#M2360 BobBistrais 2017-10-04T20:27:40Z