SchemaSpy - Table TBASE2.TBASE2.EXPLAIN_OPERATOR

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

ID

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

0

EXPLAIN_REQUESTER

varchar

128

EXPLAIN_STATEMENT.EXPLAIN_REQUESTER

SQL070118163138000

1

EXPLAIN_TIME

timestamp

16,6

EXPLAIN_STATEMENT.EXPLAIN_TIME

SQL070118163138000

2

SOURCE_NAME

varchar

128

EXPLAIN_STATEMENT.SOURCE_NAME

SQL070118163138000

3

SOURCE_SCHEMA

varchar

128

EXPLAIN_STATEMENT.SOURCE_SCHEMA

SQL070118163138000

4

SOURCE_VERSION

varchar

64

EXPLAIN_STATEMENT.SOURCE_VERSION

SQL070118163138000

5

EXPLAIN_LEVEL

char

1

EXPLAIN_STATEMENT.EXPLAIN_LEVEL

SQL070118163138000

6

STMTNO

integer

4

EXPLAIN_STATEMENT.STMTNO

SQL070118163138000

7

SECTNO

integer

4

EXPLAIN_STATEMENT.SECTNO

SQL070118163138000

8

OPERATOR_ID

integer

4

9

OPERATOR_TYPE

char

6

10

TOTAL_COST

double

8

11

IO_COST

double

8

12

CPU_COST

double

8

13

FIRST_ROW_COST

double

8

14

RE_TOTAL_COST

double

8

15

RE_IO_COST

double

8

16

RE_CPU_COST

double

8

17

COMM_COST

double

8

18

FIRST_COMM_COST

double

8

19

BUFFERS

double

8

20

REMOTE_TOTAL_COST

double

8

21

REMOTE_COMM_COST

double

8

Table contained 7,933 rows at Fri Nov 14 16:57 EST 2008