Why something like "USE INDEX a,b,c"?

On Mon, Sep 22, 2008 at 5:42 PM, Steve Friedman <[EMAIL PROTECTED]> wrote:

> As a pedant, I have two comments:
>
> - INDEX BY is a verb form.  I would think that INDEXED BY (a past
> participle) would be more accurate syntax since no new indices are being
> constructed.
>
> - I presume that the following is not contemplated (and the
> documentation should reflect this just to avoid surprises):
> SELECT * FROM (some sub-query) AS t INDEX BY ...
>
> Steve Friedman
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Seun Osewa
http://www.nairaland.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to