Correcting a minor nit: Igor Tandetnik wrote: > Magnus Manske <[EMAIL PROTECTED]> > wrote:
> The condition could be written a bit more laconically: > > pos1 BETWEEN 1 AND 1000000 > >> On my table (ca. 180K entries) this takes about 10 seconds for the >> above, which returns all rows. > > Since you are not benefitting from the index for this query, you might > get better performance by not using it: > > +pos1 BETWEEN 1 AND 1000000 > > The unary plus operator suppresses the use of the index on the affected > column, while having no effect on the value of the expression. > It seems that I am not the only one with misunderstanding that the unary plus operator has no effect on the value of the expression is wrong. See http://www.sqlite.org/cvstrac/tktview?tn=3279 to show one scenario where this operator affects the result set. Steve Friedman _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
