Reordering of predicates

### Is your feature request related to a problem or challenge?

The optimizer reorders the evaluation of the predicates in a WHERE clause according to their assigned execution cost.

If the first predicate (that is, the cheapest) in an OR optimization evaluates to TRUE, the more expensive predicates (that is, any that follow) do not have to be evaluated. Similarly, in an AND optimization, if the first predicate evaluates to FALSE, the more expensive predicates do not have to be evaluated.

### Describe the solution you'd like

_No response_

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

The issue names no files or tests; start at the optimizer logic that reorders WHERE predicates by execution cost. Clarify the intended behavior for OR and AND expressions, then define completion as an agreed solution with validation that unnecessary predicates are skipped safely.

Written by the indexing model from the issue text.