Namespace SqlPlanLine

Access predicates Example: {@code "\"RESOURCE_ID\"=:1 AND \"QUERY_ID\"=:2"}

Bytes Example: {@code 150} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Cardinality Example: {@code 1} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Cost Example: {@code 1} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

CPU cost Example: {@code 7321} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Depth Example: {@code 3} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Distribution Example: {@code "QC (RANDOM)"}

Total elapsed time Example: {@code 1.2} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Filter predicates Example: {@code "(INTERNAL_FUNCTION(\"J\".\"DATABASE_ROLE\") OR (\"J\".\"DATABASE_ROLE\" IS NULL AND SYS_CONTEXT('userenv','database_role')='PRIMARY'))"}

Identifier Example: {@code 3} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

IO cost Example: {@code 1} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Object Alias Example: {@code "PLAN_LINES@SEL$1"}

Object Instance Example: {@code 37472} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Object Name Example: {@code "PLAN_LINES_PK"}

Object Node Example: {@code "Q4000"}

Object Owner Example: {@code "TENANT_A#SCHEMA"}

Object Type Example: {@code "INDEX (UNIQUE)"}

Operation Example: {@code "SELECT STATEMENT"}

Optimizer Example: {@code "CLUSTER"}

Options Example: {@code "RANGE SCAN"}

Other Example:

Other Tag Example: {@code "PARALLEL_COMBINED_WITH_PARENT"}

Other SQL Example: {@code "<info type=\"db_version\">18.0.0.0<info type=\"parse_schema\"><info type=\"plan_hash_full\">483892784<info type=\"plan_hash\">2709293936<info type=\"plan_hash_2\">483892784"}

Parent Identifier Example: {@code 2} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Partition identifier Example: {@code 8} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Partition start Example: {@code 1}

Partition stop Example: {@code 2}

Plan hash value for the SQL Execution Plan Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Position Example: {@code 1} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Projection Example: {@code "COUNT(*)[22]"}

Qblock Name Example: {@code "SEL$1"}

Remark Example: {@code ""}

Search Columns Example: {@code 3} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Unique SQL_ID for a SQL Statement.

Time space Example: {@code 15614000} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Collection time stamp Example: {@code "2020-05-06T00:00:00.000Z"}

Version Example: {@code 1} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.