INITIATE PARTITION ANALYSIS Examples | SQL Statements | Teradata Vantage - INITIATE PARTITION ANALYSIS Examples - 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™

Example: Partition Analysis on All Tables

The following example considers partitioning expression recommendations for all tables in a workload; therefore, no ON clause specified:

     INITIATE PARTITION ANALYSIS
     FOR myworkload
     IN myqcd
     AS myppirecs;

Now you can examine the recommended partitioning expressions from this partition analysis using the following SELECT request:

     SELECT tablename, expressiontext
     FROM qcd.partitionrecommendations
     WHERE resultnametag = 'myppirecs';

Example: Partition Analysis on Specified Tables

The following example considers partitioning expression recommendations for specific tables within a workload; therefore, an ON clause is specified:

     INITIATE PARTITION ANALYSIS
     ON tab1, tab2
     FOR myworkload 
     IN myqcd
     AS myppitabrecs;

Example: Partition Analysis with a Time Limit

The following example places a 5 minute time limit on the partitioning expression analysis:

     INITIATE PARTITION ANALYSIS
     FOR myworkload
     IN myqcd
     AS myfastanalysis
     TIME LIMIT = 5;