PrepAway - Latest Free Exam Questions & Answers

What statement regarding Asynchronous index cleanup (AIC) is correct?

What statement regarding Asynchronous index cleanup (AIC) is correct?

PrepAway - Latest Free Exam Questions & Answers

A.
AIC removes all invalid index entries that refer to the attached partitions.

B.
AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.

C.
AIC activates a newly attached partition after the index entries have been synchronized.

D.
AIC will not be initiated if a range-partitioned table has dependent materialized query tables
–(MQTs).

Explanation:


Leave a Reply