Where vs Join performance

[pabloBelt]

Hi,

Where conditions implementation are inefficient in AlaSQL compared to Join conditions.

select * from X, Y where Y.B = X.A and Y.C > 100
vs
select * from X join Y on Y.B = X.A and Y.C > 100

Idea: Should where conditions converted into Join conditions in some way to reuse the exisintg Join implementation. Is that feasible in AlaSQL?

Regards,
Pablo

[pabloBelt]

It seems that there is already something in regard to this. I'll have a look at

[mathiasrw]

Go for it!