Enterprise Data Manager Guide

Back Next

Table Tokens

You can use tokens to help create some of the performance hints available under the

Tables

tab. During runtime, the segmentation process replaces the tokens with the actual table or index names, and parameter values.

The following table describes table tokens:

Token Name	Hint Column	Description
$SEL_TABLE$	Insert Update Hint Text	Use as a substitute for the selection table name.
$PARTITIONED_TAB_INDEX$	Default Segment Select Hint	Use as a substitute for the index name of the segmented table.
$PARTITIONED_TABLE$	Default Segment Select Hint	Use as a substitute for the name of the segmented table.
$INTERIM_TABLE$	History Segment Sub Query Hint	Use as a substitute for the name of the interim table.
$INTERIM_INDEX$	History Segment Sub Query Hint	Use as a substitute for the name of the interim table index.
$DML_PARALLEL_DEGREE$	Insert Update Hint Text	Use as a substitute for the value of the "Parallel_Degree_Insert_Only" parameter in the Manage Segmentation Setup page.