Search

Top 60 Oracle Blogs

Recent comments

Home

AUTO_INDEX_COMPRESSION

Oracle Database 19c Automatic Indexing: Index Compression Update (New Morning)

Submitted by Richard Foote on Wed, 2021-01-27 05:41

  I was reminded in a recent comment by Rajeshwaran Jeyabal that I hadn’t updated my post on Automatic Indexing with Advanced Compression that’s in need of a couple of amendments. Initially when Automatic Indexing was released, the ability to set Advanced Compression was NOT included in the official documentation, although the EXEC DBMS_AUTO_INDEX.CONFIGURE( ‘AUTO_INDEX_COMPRESSION‘ […]

Oracle Database 19c Automatic Indexing: Index Compression (Ghosteen)

Submitted by Richard Foote on Mon, 2019-12-09 03:01

    In my previous post on Automatic Indexing, I discussed how the default index column order (in absence of other factors) is column id, the order in which the columns are defined in the table. In this post, I’ll explore if this changes if index compression is also implemented. By default, Automatic Indexing does […]

Oracle 19c Automatic Indexing: Configuration (All I Need)

Submitted by Richard Foote on Mon, 2019-07-29 05:12

In this post, I’ll discuss how to configure the new Automatic Indexing capability introduced in Oracle Database 19c. The intent of Oracle here is to make the configuration of Automatic Indexing as simplistic as possible, with as few levers for DBAs to potentially stuff up as possible. The ultimate goal would be to have a […]