Example: Include NUSI and Simple Join Indexes Only in the Analysis - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

This example considers only NUSIs and simple single-table join indexes for the index analysis.

     INITIATE INDEX ANALYSIS ON tab1
     FOR MyWorkload
     IN MyQCD AS tab1Index
     WITH INDEX TYPE 4, 5;