Search

Top 60 Oracle Blogs

Recent comments

Index Shrink

Oracle 19c Automatic Indexing: DDL Statements With Auto Indexes (No Control)

  I’ve had a number of questions in relation to DDL support for Automatic Indexes since my last post on how one can now drop Automatic Indexes, so decided to quickly discuss what DDL statements are supported with Automatic Indexes. Many DDL commands are NOT supported with Automatic Indexes, such as making indexes (IN)VISIBLE and […]