title: In which cases will Oracle create indexes automatically?
body: <p>As far as I know (<a href="http://infolab.stanford.edu/~ullman/fcdb/oracle/or-nonstandard.html#indexes" rel="noreferrer">this page</a>) 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?</p>