Simple example - Schema Objects Index

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips

A B C D E F I O P Q R S T V t

A

ACCESS_PREDICATES column of table PLAN_TABLE

B

BYTES column of table PLAN_TABLE

C

CARDINALITY column of table PLAN_TABLE
COL column of table ENCODING
COL column of of view VENCODING
COLUMN1 column of table TABLE1
COLUMN1 column of table TABLE2
COLUMN1 column of of view VIEW1
COLUMN2 column of table TABLE1
COLUMN2 column of table TABLE2
COLUMN2 column of of view VIEW1
COLUMN3 column of table TABLE1
COLUMN3 column of table TABLE2
COLUMN3 column of of view VIEW1
COLUMN4 column of table TABLE1
COLUMN4 column of table TABLE2
COLUMN4 column of of view VIEW1
COLUMN5 column of table TABLE1
COLUMN5 column of table TABLE2
COLUMN5 column of of view VIEW1
COLUMN6 column of table TABLE2
COST column of table PLAN_TABLE
CPU_COST column of table PLAN_TABLE

D

DEPTH column of table PLAN_TABLE
DISTRIBUTION column of table PLAN_TABLE

E

ENCODING table

F

FILTER_PREDICATES column of table PLAN_TABLE
FUNCTION1 function

I

ID column of table PLAN_TABLE
IOFT_VENCODING Trigger on view VENCODING
IO_COST column of table PLAN_TABLE

O

OBJECT_ALIAS column of table PLAN_TABLE
OBJECT_INSTANCE column of table PLAN_TABLE
OBJECT_NAME column of table PLAN_TABLE
OBJECT_NODE column of table PLAN_TABLE
OBJECT_OWNER column of table PLAN_TABLE
OBJECT_TYPE column of table PLAN_TABLE
OPERATION column of table PLAN_TABLE
OPTIMIZER column of table PLAN_TABLE
OPTIONS column of table PLAN_TABLE
OTHER column of table PLAN_TABLE
OTHER_TAG column of table PLAN_TABLE
OTHER_XML column of table PLAN_TABLE

P

PARENT_ID column of table PLAN_TABLE
PARTITION_ID column of table PLAN_TABLE
PARTITION_START column of table PLAN_TABLE
PARTITION_STOP column of table PLAN_TABLE
PKG1 package
PLAN_ID column of table PLAN_TABLE
PLAN_TABLE table
POSITION column of table PLAN_TABLE
PROCEDURE1 procedure
PROJECTION column of table PLAN_TABLE

Q

QBLOCK_NAME column of table PLAN_TABLE

R

REMARKS column of table PLAN_TABLE

S

SEARCH_COLUMNS column of table PLAN_TABLE
STATEMENT_ID column of table PLAN_TABLE
SYS_IL0000052193C00036$$ index on table PLAN_TABLE

T

TABLE1 table
TABLE2 table
TEMP_SPACE column of table PLAN_TABLE
TIME column of table PLAN_TABLE
TIMESTAMP column of table PLAN_TABLE
TRIGGER1 Trigger on table TABLE1

V

VENCODING view
VIEW1 view

t

t1t2fk constraint on table TABLE1
t2pk index on table TABLE2
t2pk constraint on table TABLE2