Thanks a lot Simon. Are there any projects where , sqlite optimizer has been extended to add System R or other algorithms ? I browsed through the github repository and could not find any.
Thanks a lot for your time. Regards Prakash On Thu, Oct 16, 2014 at 12:49 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 16 Oct 2014, at 7:50am, Prakash Premkumar <prakash.p...@gmail.com> > wrote: > > > Does sqlite implement the pointers in the System R Algorithm ? > > SQLite does not implement the System R Algorithm, so no, it doesn't > implement the pointers from System R. It implements the algorithms > described in the two references just cited. Those algorithms have some > things in common with System R but are not the same as it. > > > Like > > assigning selectivity factors for predicates in where clause? > > SQLite does something equivalent to this. Read about the ANALYZE command > which is documented on the SQLite web site, and examine the type of data it > puts in the tables it creates. The ANALYZE command is discussed in the two > references just cited. > > You've asked some detailed questions on this list which could be answered > by reading the documentation available to on the SQLite web site. It might > be worth trying to get your answers from the web site first, and if you > still want to post, citing the pages you've already read so we don't point > them out to you in our own answers. > > Simon. > _______________________________________________ > sqlite-users mailing list > email@example.com > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users