View Editor

View Name

The same rules as for table names apply: Table Name (table_name)

Schema

Schema Name (schema_name)

Replace Existing View

If you choose these option, the view table replaces a previously existing view table.

Check on Insert and Update

If this option is set, you cannot use INSERT or UPDATE statements on the view table to generate any rows that can afterwards no longer be selected via the view table. Resulting rows must fulfill the view table's search condition.

The option is inherited. This means that, if you have defined a view table VIEWTABLE1 with this option and are using VIEWTABLE1 in the FROM condition of a modifiable view table VIEWTABLE2, then only rows that can be selected using VIEWTABLE1 may be added or modified with VIEWTABLE2.

View Column

Column name in the view table

Table Schema

Schema

Table Name

Name of the base table

Table Column

Name of the column in the base table

Data Type

Data Type (data_type)

Dim

Dimension

Maximum number of characters

Code

Code Attribute

Tenant Type

Only in multi-tenant systems

Tenant type

Not Null

If you select this option, the value for this column cannot be a NULL value.

Column Attributes (column_attributes)

Default

Default value

Only Bad Indexes

Only damaged indexes are displayed.

Only Disabled Indexes

Only disabled indexes are displayed.

Only Unused Indexes

Only unused indexes are displayed ( INDEXUSED=0).

Type

Indicates whether or not the index is Unique

Index Used

Indicates how often the system has used the index

Index Used Reset Time

Time when the counters for index use were reset

File State

Indicates whether the index is damaged

Disabled

Deactivated

Columns and Indexes

Columns and indexes

Different Values

Estimated number of rows in the table

If there is a big difference between the value in this column and the value in the Different Values (Exact) column, we recommend that you update the SQL optimizer statistics. For more information, see SQL Optimizer, SQL Optimizer Statistics.

Different Values (Exact)

Number of rows in the table (information from the internal file directory)

Pages

Estimated table size in pages

This size affects which search strategy is selected by the system, see SQL Optimizer, Search Strategies.

If there is a big difference between the value in this column and the value in the Pages (Exact) column, we recommend that you update the SQL optimizer statistics.

Pages (Exact)

Table size in pages (information from the internal file directory)

Last Statistics Update

Time of the last statistics update

SQL Statement with which the view table has been created