Object Types

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

Supported object types

Exasol 8 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 zero.
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 script object is zero.
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 zero.

To view object sizes, use EXA_ALL_OBJECT_SIZES.