17.05 - EXPLAIN Request Modifier with a DELETE Statement - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

This EXPLAIN request modifier shows the steps performed to execute the DELETE statement and the outcome of the application of the DELETE and SELECT constraints.

       EXPLAIN DELETE FROM rls_tbl WHERE col1=2;

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.