Thanks for your reply Simon. I have read through those links. Does sqlite implement the pointers in the System R Algorithm ? Like assigning selectivity factors for predicates in where clause? Link to System R Algorithm: https://www.cs.duke.edu/courses/spring03/cps216/papers/selinger-etal-1979.pdf
Thanks a lot for your time. Regards Prakash On Wed, Oct 15, 2014 at 5:36 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 15 Oct 2014, at 12:54pm, Prakash Premkumar <prakash.p...@gmail.com> > wrote: > > > I'm trying to understand the sqlite select query optimizer. It works by > > assigning costs to each relation in FROM clause. > > That is only a little bit of how it works. Have you read these ? > > <https://www.sqlite.org/optoverview.html> > <https://www.sqlite.org/queryplanner-ng.html> > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users