When table scans are used for or queries

A query with or clauses or an in (values_list) uses a table scan if either of these conditions is true: