You have created an Access Definition containing multiple tables. The tables each have primary keys and additional non-unique indexes that have been added over the years. While defining this archive request you have the choice of defining archive indexes. Which statement is true?

You have created an Access Definition containing multiple tables. The tables each have primary keys and additional non-unique indexes that have been added over the years. While defining this archive request you have the choice of defining archive indexes. Which statement is true?
A . Archive indexes do not need to be defined since Optim has already detected and included the indexes in the archive request.
B . Archive indexes will automatically be created to mirror the indexes that exist on the tables in the archive request.
C . Archive indexes should be specified in the Access Definition to match all of the indexes on the tables.
D . Archive indexes should be specified in the Access Definition that will support the query workload planned for the archived data.

View Answer

Answer: D