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.
In the context menu of the table, choose Definition.
In the context menu of the editor window, choose Edit.
Open the Miscelleous tab page.
Enter the required data.
Property |
Description (Link to SQL Reference Manual) |
---|---|
Sample Type |
Sample type that the system uses for the statistics of the SQL Optimizer More information:
|
Sample Data |
Sample value (in data records or percent) that the system uses for the statistics of 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. |
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).