Object Types

This article explains how the raw (uncompressed) size is determined for different object types in Exasol.

Supported object types

Exasol supports the following object types:

• Function

• Schema

• Script

• Table

• View

To view a list of all objects that you have access to, use EXA_ALL_OBJECTS.

Object type raw sizes

The following table describes how the raw (uncompressed) size is determined for each object type.

Data type	Raw size in bytes
FUNCTION	The raw size of a function object is the size of the declarative SQL text used in the CREATE FUNCTION statement.
SCHEMA	The raw size of a schema object is the sum of the raw size of all the objects contained in the schema, such as tables.
SCRIPT	The raw size of a view object is the size of the declarative SQL text used in the CREATE SCRIPT statement.
TABLE	The raw size of a table object is the sum of the raw size of all the columns in the table.
VIEW	The raw size of a view object is the size of the declarative SQL text used in the CREATE VIEW statement.

To view object sizes, use EXA_ALL_OBJECT_SIZES.