Woody Wu wrote: > On 2014年5月8日 GMT+08:00PM9:14:52, Clemens Ladisch <clem...@ladisch.de> wrote: >> Woody Wu wrote: >>> what's the best index in the case of (1) B is an existed one, or (2) >>> B is not exists ? >> >> That depends. Create two indexes on (b,c,a) and (c,b,a), run ANALYZE, >> and check which one gets actually used. > > Thanks Clemen, could you please tell me how to use this analyze command for > the case?
Just execute "ANAYLZE". To check which index is used by the query, you have to execute this query with EXPLAIN QUERY PLAN. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
