Hello,
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.
What is the best practice for indexing a table with Archiving?
Does indexing index the whole table or just the un-archrived values (ex: GDB_TO_DATE = xx/xx/9999)?
edit: I looked at the Object ID index and it is not unique, so I am assuming indexing works at the database level.
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?
Regards,
Jim
