Other Operation Icons - Visual Explain

Teradata Visual Explain User Guide

Product

Visual Explain

Release Number

15.10

Language

English (United States)

Last Update

2018-10-07

dita:id

B035-2504

lifecycle

Product Category

Teradata Tools and Utilities

Table 20 describes the Teradata Visual Explain icons used to depict other operations.

Table 20: Other Operation Icons
Icon	Operation	Function
	Merge-Delete	Merge the data, then delete it from the table.
	Merge	Perform a single‑row merge.
	Multiple‑row merge	Perform a multiple‑row merge.
	Update	Update data in a table.
	Merge Update	Update merged data in a table.
	Bitmap	Insert bitmap images into a table.
	Insert	Insert rows into a table.
	Delete	Delete specified rows from a table.
	Abort	Terminate the current transaction.
	Materialized temporary trace table step	Realize temporary tables (actual creation and data insertion).
	Sort step	Sort the rows in a target relation and eliminates duplicate rows.
	Spoil step	Spoil the dictionary cache.
	Flush Database step	Flush the DISKSPACE and AMPUSAGE caches.
	Begin Loading	Initiate loading process.
	Create Index Subtable	Create Index Subtable on table.
	Modify Table Header	Modify the Table Header.
	Modify Table Version	Modify Table Version in the data dictionary.
	Insert Access Rights	Insert Access Rights in the data dictionary.
	Create Table Header	Create a Table Header.
	Drop Table Header	Drop the Table Header.
	End Logging	End logging on the table.
	Set Query Band	Identifies the type and source of a query to determine prioritization of queries.
	Save updated stats	Save the updated Statistics for columns of a table.
	Collect Stats	Collect Stats for the given Table or Columns.
	End Mload	Signifies the end of the task script and initiates task processing by the Teradata Database.
	Begin Mload	Initiates or restarts a Multiload import task.
	Mload Job	Invokes Multiload
	Check Workload Step	Check Workload during Mload.
	Checkpoint Loading	Checkpoints are entries posted to a restart log table at regular intervals of a data transfer operation.
	Configuration Information	Describes the Configuration Information.
	Fast Load Insert	INSERT is a Teradata SQL statement that inserts data records into the rows of the Teradata FastLoad table.
	Edit DML step for MLOAD	Edit DML step for MLOAD controls the processing of an MLOAD insert, update, or delete step.