On 21 Mar 2011, at 2:17pm, Guilherme Batista wrote: > So, in general, the the ANALYZE is not advantageous only if I have just 1 > index in my table, in that case the sqlite never use the ANALYZE...
If you have exactly one INDEX which looks helpful for the query, SQLite will just use that. It won't even bother checking to see if another way of searching might be faster. (This is a little simplified from real life, I think, but gives you the most useful answer.) > Obviously the already defined indexes are updated automatically when I > insert new data into my tables right? Right. Also when you delete or update existing rows. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
