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 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.