Procedure documentationDefining Custom Table Properties Locate this document in the navigation structure

Prerequisites

  • You are logged on to the database as a database user.

  • You have the ALTER privilege for the table.

    More information: SQL Reference Manual, Privilege Specification (priv_spec)

  • The database is in the ONLINE operational state.

Procedure

  1. Select the table in the explorer tree.

  2. In the context menu of the table, choose Definition.

  3. In the context menu of the editor window, choose Edit.

  4. Open the Miscellaneous tab page and change the relevant properties.

    Table: Miscellaneous

    Property

    Description (Link to SQL Reference Manual)

    Sample Type

    Sample type that the system uses for estimating the statistics for the SQL Optimizer

    More information:

    Sample Data

    Sample value (in data records or percent) that the system uses for estimating the statistics for the SQL Optimizer

    Table Size

    Information about the current table size

    Clustered

    Only for SAP NetWeaver BI systems with BW Feature Pack

    This attribute has the result that the database does not distribute pages in single blocks of 8 KB across all volumes, rather, where possible it saves the contents in larger, contiguous blocks in the data volumes.

    More information:

    Virtual Primary Key

    Only for SAP NetWeaver BI systems with BW Feature Pack

    For tables which have no primary key, the system forms a primary key internally and sets the Clustered attribute. Columns which the system uses for the primary key do not need to have the UNIQUE attribute.

    Packed

    Only for SAP NetWeaver BI systems with BW Feature Pack

    The system stores numerical columns that are not key columns in compressed form.

  5. In the context menu of the editor window, choose Create Table (if you are creating a new table) or Alter Table (if the table already exists).