Using indexes

Indexed columns in WHERE clauses speeds up queries when a small number of rows are returned
For queries of large datasets and each column contains a small amount of data, full table scans may be faster than index scans
When a new index is introduced, the performance should be measured
Remember, CBO may choose full table scan despite fine indexes

Indexed columns in WHERE clauses speeds up queries when a small number of rows are returned