Ordering table scans

2019-02-22 Thread Gopalakrishna Holla
Hello, The problem I'm working on is to order table scans so that one scan can insert filters into the another. It seems like it should be a common problem so I'm sure I'm missing some context. Taking a concrete example, imagine two tables Users and Movies with the following schema User { id: l

Re: Ordering table scans

2019-02-26 Thread Gopalakrishna Holla
Thank you for the pointers ! Will take a look On Fri, Feb 22, 2019 at 5:39 PM Walaa Eldin Moustafa wrote: > Also, since you are particularly interested in applying filters from > one table on another, that is actually a nested loops join rather than > a filter. Linq4j implementation has examples