SELECT * FROM MEMBER WHERE MEMER.Mem_dEffect<=m.ldDate AND MEMBER.Mem_dExpire>=m.ldDateIt would seem either of these two would be fully optimized.
SELECT * FROM MEMBER WHERE m.ldDate BETWEEN MEMBER.Mem_dEffect AND MEMBER.Mem_dExpire SELECT * FROM MEMBER WHERE BETWEEW(m.ldDate, MEMBER.Mem_dEffect,MEMBER.Mem_dExpire)But with these optimization is only partial. Couldn’t you make the engine smart enough to figure this out and fully optimize it?
SELECT * FROM MEMBER WHERE MEMBER.Mem_dExpire = {} is fully optimized but SELECT * FROM MEMBER WHERE EMPTY(MEMBER.Mem_dExpire) is not.Again, couldn’t you make the engine smart enough to figure this out and fully optimize it?