Example: Using a CHECKPOINT - Analytics Database - Teradata Vantage

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;