I am currently learning indexes in Oracle. In Oracle documentation, following can be found :
Although the database creates an index for you on a column with an integrity constraint, explicitly creating an index on such a column is recommended.
Can anybody here tell me the rationale behind this ? If database creates an index automatically, why should we create another index on those columns explicitly ?