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.
Select the table in the explorer tree.
In the context menu of the table, choose Definition.
In the context menu of the editor window, choose Edit.
Open the Miscellaneous tab page and change the relevant properties.
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. |
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).