You should specify the CHECKPOINT option for long operations and for workloads containing many SQL requests that must be analyzed. The checkpoint_trigger value indicates the frequency with which a checkpoint is taken. After every checkpoint_trigger number of SQL requests, a checkpoint is taken and completed IndexRecommendation information is saved in the AnalysisLog table in the QCD.
INITIATE INDEX ANALYSIS ON table_1 FOR MyWorkload IN MyQCD AS table_1Index SET IndexesPerTable = 2 KEEP INDEX CHECKPOINT 10;