Managing Partitions, Indexes, Indextypes, and Materialized Views

Autonomous Database allows manual creation of partitioned tables, indexes, and materialized views using the partitioning clause in the CREATE TABLE statement, the CREATE INDEX statement, and the CREATE MATERIALIZED VIEW statement respectively.

Oracle recommends that you do not manually create these structures, and leave performance optimizations to the Autonomous Database. If you're a highly skilled Oracle Database tuning expert and decide to manually create these access structures, please be advised to test the impact of your manual tuning efforts on your full workload.

Autonomous Database supports Automatic Partitioning that analyzes and automates partition creation for tables and indexes of a specified schema to improve performance and manageability. Automatic Partitioning, when applied, is transparent and does not require any user interaction or maintenance. Automatic Partitioning analyzes the application workload and automatically applies partitioning to tables and their indexes to improve performance or to allow better management of large tables. See Manage Automatic Partitioning on Autonomous Database for more information.

Autonomous Database furthermore allows the creation of indextypes using the CREATE INDEXTYPE statement. Indextypes are database objects that specify the routines that manage a domain index, encapsulating search and retrieval methods for complex domains. Any implementation that is not purely in-database or provided by Autonomous Database, such as text indexing, will not work.