Simple cost based rearrangement of logial operators can help a lot

[kaikalur]

I have seen some queries that do a ton of REGEXP_LIKE(..) AND v >= 0.9. And we generally maintain the order of the subexpressions. But in this case the trivial v >= 0.9 comparison is a lot cheaper. So rearranging them so all function calls are towards the latter part of the eval like v >= 0.9 AND REGEXP_LIKE(..), it could be more efficient.

[sguo35]

@kaikalur Can I take a stab at this?

[tsafacjo]

can I take this isssue ?

[kaikalur]

can I take this isssue ?

Please feel free!

[tsafacjo]

ok, thanks !