On 4/11/2024 15:23, Stepan Yankevych wrote:
Let's classify it as possible improvement / new feature for further
releases.
Optimizer definitely should be able to add that extra (redundant)
condition *and e.exec_date_id >= 20241021*
or even transform* e.exec_date_id >= co.create_date_id *
to *e.exec_date_id >= **20241021*
Not sure it would be easy (and make sense) to implement it as a core
feature. But the idea of the extensibility of the clause deduction
system looks spectacular to me.
--
regards, Andrei Lepikhov