Alex Rivera | Logout

In which cases will Oracle create indexes automatically?

Asked 2010-01-28T11:27:58.850
27

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?

database oracle-database indexing
Edit
Report

1 Answer

3

And another one, if you create a table with a nested table you get an index created automatically. Object based storage in general can do this as there can be hidden tables created.

I think schema-based XMLTypes will also do it.

answered 2010-01-28T22:11:40.367

Your Answer