Object Types

This section 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.