https://community.esri.com/t5/geodatabase-questions/archriving-and-unique-ids/m-p/1217962#M7908 <P>Hello,</P><P>I need some guidance for Indexing with Archiving enabled. I am getting an error to apply a unique index to a table with Archiving enabled. I understand that in the Data Base there is a duplication of the ID because of Archiving. Any help with the three questions below would be awesome.&nbsp;</P><P>What is the best practice for indexing a table with Archiving?</P><P>Does indexing index the whole table or just the un-archrived values (ex: GDB_TO_DATE = xx/xx/9999)?</P><P><EM>edit: I looked at the Object ID index and it is not unique, so I am assuming indexing works at the database level. </EM></P><P>If I make a unique Index with multiple values like unique_Id+GlobalID+GDB_TO_DATE does this help the performance of joins where only the unique_id is used? Or can I only index one column ex: just the unique_Id to help performance of a join?</P><P>Regards,</P><P>Jim</P><P>&nbsp;</P> Fri, 30 Sep 2022 17:41:52 GMT JimWilliams 2022-09-30T17:41:52Z https://community.esri.com/t5/geodatabase-questions/archriving-and-unique-ids/m-p/1217962#M7908 <P>Hello,</P><P>I need some guidance for Indexing with Archiving enabled. I am getting an error to apply a unique index to a table with Archiving enabled. I understand that in the Data Base there is a duplication of the ID because of Archiving. Any help with the three questions below would be awesome.&nbsp;</P><P>What is the best practice for indexing a table with Archiving?</P><P>Does indexing index the whole table or just the un-archrived values (ex: GDB_TO_DATE = xx/xx/9999)?</P><P><EM>edit: I looked at the Object ID index and it is not unique, so I am assuming indexing works at the database level. </EM></P><P>If I make a unique Index with multiple values like unique_Id+GlobalID+GDB_TO_DATE does this help the performance of joins where only the unique_id is used? Or can I only index one column ex: just the unique_Id to help performance of a join?</P><P>Regards,</P><P>Jim</P><P>&nbsp;</P> Fri, 30 Sep 2022 17:41:52 GMT https://community.esri.com/t5/geodatabase-questions/archriving-and-unique-ids/m-p/1217962#M7908 JimWilliams 2022-09-30T17:41:52Z