[firebird-support] How does the optimizer of Firebird determine join order?

2014-05-14 Thread Zhan Li zhanl...@gmail.com [firebird-support]
Hi All, I've been studying the optimizer of firebird for a while, and I was wondering how the optimizer chooses join order? As most query optimizers determine join order via a dynamic programming algorithm pioneered by IBM's System R database project, does the optimizer of firebird use similar

Re: [firebird-support] How does the optimizer of Firebird determine join order?

2014-05-14 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, May 13, 2014 at 10:37 PM, Zhan Li zhanl...@gmail.com[firebird-support] firebird-support@yahoogroups.com wrote: Hi All, I've been studying the optimizer of firebird for a while, and I was wondering how the optimizer chooses join order? As most query optimizers determine join order