Methods for processing or clauses

A single-table query including or clauses is a union of more than one query. Although some rows may match more than one of the conditions, each row must be returned only once. Depending on indexes and query clauses, or queries can be resolved by one of these methods: