In which cases will Oracle create indexes automatically?

database, indexing, oracle

Solution

I'll try to consolidate given answers and make it community wiki. So indexes are automatically created by Oracle for such cases:

- APC: For primary key and unique key unless such indexes already exist.

- APC: For LOB storage and XMLType.

- Gary: For table with a nested table.

- Jim Hudson: For materialized view.

Problem

As far as I know (this page) Oracle automatically creates an index for each UNIQUE or PRIMARY KEY declaration. Is this a complete list of cases when indexes are created automatically in Oracle?

Original source