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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
