On Wed, Jan 23, 2019 at 9:44 AM Donald Dong <xd...@csumb.edu> wrote: > > 1. Enumerate all the plans >
Not sure this is going to work. Because of the total number of possible plans is somewhere around O(n!), if I'm not mistaken, in terms of number of joined relations times the available access methods times the possible join strategies. So enumerating all possible plans stops being practical for even slightly complicated queries. Regards, -- Alex