EXPLAIN Text - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

EXPLAIN Text

The system returns this EXPLAIN text.

 *** Help information returned. 10 rows.
 *** Total elapsed time was 1 second.
 
Explanation
----------------------------------------------------------------------
  1) First, we do a single-AMP DELETE from RS.rls_tbl by way of the
     primary index "RS.rls_tbl.col1 = 2" with a residual condition of (
     "((SYSLIB.DELETELEVEL (RS.rls_tbl.levels ))= 'T') AND
     (((SYSLIB.SELECTLEVEL (2, RS.rls_tbl.levels ))= 'T') AND
     (((SYSLIB.DELETECATEGORIES (RS.rls_tbl.categories ))= 'T') AND
     ((SYSLIB.SELECTCATEGORIES ('90000000'XB, RS.rls_tbl.categories ))=
     'T')))").  The size is estimated with no confidence to be 2 rows.
     The estimated time for this step is 0.01 seconds.
  -> No rows are returned to the user as the result of statement 1.
     The total estimated time is 0.01 seconds.
  • “DELETE (Positioned Form)” in SQL Stored Procedures and Embedded SQL
  • “DELETE (Temporal Form)” in Temporal Table Support
  • “DELETE (ANSI System-Time Form)” in ANSI Temporal Table Support
  • “DELETE (ANSI Valid-Time Form)” in ANSI Temporal Table Support
  • “DELETE (ANSI Bitemporal Table Form)” in ANSI Temporal Table Support