Some notes on Oracle Indexes
Oracle Indexes The degree to which indexes help performance depends partly on the selectivity of the data.High selectivity – Few rows match the index valueLow selectivity – like Country name returns many rows from the index If data is selective but the rows are not stored near each other in the table, many blocks may …