Please enable JavaScript to view this site.

Data Dictionary Data Model

Navigation: » No topics above this level «

SYSTEMSQLEXECUTIONSTEPS: Data Dictionary SQL Execution Steps

Contents Previous Home Next More

Individual processing steps executed by the Invantive SQL engine during the execution of SQL statements, their relationships and their statistics.

Catalog: DataDictionary

Schema: Invantive

Alias: sep

Label: SQL Execution Steps

This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.

View Columns

The columns of the view SYSTEMSQLEXECUTIONSTEPS are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

ALIAS

string(240)

Alias

Alias of the result set.

COLUMNS_IN

int32

Columns In

Number of columns input.

COLUMNS_OUT

int32

Columns Out

Number of columns output.

DEPTH

int32

Depth

 

Depth of the step.

DESCRIPTION

string(240)

Description

Description of the step.

DURATION_MS

int64

Duration (ms)

 

Duration in milliseconds of the step.

DURATION_TICKS

int64

Duration (Ticks)

 

Duration in ticks of the step.

END_TIME_UTC

datetime

End Time

Time at which the SQL execution was ended (UTC).

ID

int32

ID

 

Unique ID of the step.

PARAMETERS

string(240)

Parameters

Parameters of the step.

PARENT_ID

int32

Parent ID

 

ID of the parent step.

ROWS_IN

int64

Rows In

Number of rows input.

ROWS_OUT

int64

Rows Out

Number of rows output.

START_TIME_UTC

datetime

Start Time

Time at which the SQL execution step was started (UTC).

 

17-05-2021 11:57 Version 20.1.419-BETA+3191