BigdataLyn's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle 19c Automatic Indexing

2019-02-19
 

Oracle 19c Automatic Indexing

19C has a new feature database 19c is automatic indexing.

AI

Database Licensing Information User Manual

[OnP] Automatic Indexing is supported by only Exadata(ODA can NOT be supported)

It can be supported via SE in Cloud.

21.7 Managing Auto Indexes

Automatic indexing is disabled by default in an Oracle database. 

To enable automatic indexing, set the AUTO_IMPLEMENT_INDEXES initialization parameter to the Oracle database release number, 

for example, 19.1. You can disable automatic indexing by setting the AUTO_IMPLEMENT_INDEXES initialization parameter to NONE.

Method

Some parameters with Automatic Indexing and it can be executed by DBMS_AUTO_INDEX package

SQL> EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_DEFAULT_TABLESPACE','INDEX_TS');

Parameter

Some other advisor:

Index Advisor, Partition Advisor, In-Memory Advisor, etc.

Have a good work&life! 2019/02 via LinHong


Similar Posts

Comments