Re: [sqlite] Indices recreation

Am Donnerstag, den 22.09.2011, 20:28 +0100 schrieb Simon Slavin: > Indexes are not recreated from scratch unless you explicitly ask for them to > be (rare). If you open a database with a million rows in and add or change a > row, the indexes for that table are each modified slightly to reflect

Re: [sqlite] Indices recreation

recreation only once, wouldn't it? best regards JM Am Donnerstag, den 22.09.2011, 18:43 +0100 schrieb Simon Slavin: > On 22 Sep 2011, at 5:30pm, Jay A. Kreibich wrote: > > > Indexes are updated automatically. > > As they are with all implementations of SQL. That's

[sqlite] Indices recreation

the index manually or will the recreation of the index be handled automatically by sqlite? I couldn't find this information in the sqlite documentation. Regards JM ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

[sqlite] SQL question with SQLite

Hello, In a SELECT statement with multiple tables, is it possible to replace WHERE clauses used to avoid cross joins with GROUP BY + HAVING clauses (with the same criteria) for the same purpose (no cross join) ? Are the two methods roughly equivalent in performance ? We ask this because we