Oracle: Give the reasoning behind using an index?

Answer 1

Reason for using Index:

To quickly find specific rows by avoiding a Full Table Scan.

To avoid a table access altogether.

To avoid a sort.