Access Methods and Costing for or and in Clauses

When a query on a single table contains or clauses or an in (values_list) clause, it can be optimized in different ways, depending on the presence of indexes, the selectivity of the search arguments, the existence of other search arguments, and whether or not the clauses might return duplicate rows.