RESTART INDEX ANALYSIS | SQL Statements | Teradata Vantage - RESTART INDEX ANALYSIS - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™

Restarts a previously halted index analysis started by an INITIATE INDEX ANALYSIS or RESTART INDEX ANALYSIS request that specified a checkpoint.

For more information about index analysis, see:

ANSI Compliance

RESTART INDEX ANALYSIS is a Teradata extension to the ANSI SQL:2011 standard.

Required Privileges

The privileges required to submit a RESTART INDEX ANALYSIS request are the following:

You must have this privilege set … On this table set in database QCD_name
INSERT
  • IndexColumns
  • IndexRecommendations
  • INSERT
  • DELETE
AnalysisLog

The user who performs a RESTART INDEX ANALYSIS request must be the same user who performed the checkpointed INITIATE INDEX ANALYSIS request.

Rules for Performing RESTART INDEX ANALYSIS

The rules for using RESTART INDEX ANALYSIS and INITIATE INDEX ANALYSIS are the same. For more information, see Rules for Performing INITIATE INDEX ANALYSIS.

RESTART INDEX ANALYSIS Requires a Checkpoint

If you do not specify a CHECKPOINT clause in your INITIATE INDEX ANALYSIS request, then you cannot restart a previously halted index analysis.

If you are not satisfied with the outcome of a previously timed out INITIATE INDEX ANALYSIS request and want to extend the analysis with the intent of achieving better results, you can restart the analysis from the point at which it was stopped by specifying a CHECKPOINT rather than redoing the entire INITIATE INDEX ANALYSIS request from the beginning.

Actions Performed by RESTART INDEX ANALYSIS

RESTART INDEX ANALYSIS functions like INITIATE INDEX ANALYSIS, except that RESTART INDEX ANALYSIS begins its analysis with the first SQL request in the workload that was not checkpoint logged in the AnalysisLog table.

If the restart aborts for any reason before completion, the next RESTART INDEX ANALYSIS request begins its analysis with the first SQL request in the workload that was not checkpointed in the AnalysisLog table.

Once the restart completes successfully, index recommendations are written to the IndexRecommendations table within the specified QCD.

RESTART INDEX ANALYSIS Not Supported From Macros

You cannot specify a RESTART INDEX ANALYSIS request from a macro. If you execute a macro that contains a RESTART INDEX ANALYSIS request, the database aborts the request and returns an error.