Hi, I'm trying to understand the sqlite select query optimizer. It works by assigning costs to each relation in FROM clause. As far as I understand, it primarily uses the logarithmic estimate of the number of rows in the relation.
Query optimization algorithms like IBM System R algorithm assigns weight to predicates in WHERE clause in addition to the number of rows. Can that be implemented for sqlite /what are other optimizations that are available in other databases like postgres,MySQL that can be ported to SQLite. Thanks for sharing your ideas. Regards Prakash _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
