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.


On Thu, Oct 16, 2014 at 12:49 PM, Simon Slavin <> wrote:

> On 16 Oct 2014, at 7:50am, Prakash Premkumar <>
> 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 mailing list

Reply via email to