The sole purpose of indexes in any relational database management system is to reduce the access time for SQL statements. The SQL optimizer can detect when and indexes present, and use sophisticated algorithms in order to determine the fastest way of accessing the data. If indexes did not exist in a relational database the Oracle database SQL optimizer would have no choice except to read every single row in the table.