The following table lists the objects for which physical options are available when working with a particular DBMS:
|
Database |
Objects supporting physical options |
|---|---|
|
Sybase AS Anywhere |
Table, Index, Database, Tablespace |
|
Sybase AS Enterprise |
Table, Index, Key, Database |
|
IBM DB2 for Common Server |
Table, Column, Index, View, Storage, Tablespace |
|
IBM DB2 for OS/390 |
Table, Column, Index, Database, Storage, Tablespace |
|
Microsoft SQL Server |
Table, Index, Key, Database |
|
Oracle |
Table, Key, Index, View, Join Index, Sequence, Database, Tablespace, Storage |
For detailed information about these options, see your database documentation.