2015-12-12 19:17 GMT+01:00 Simon Slavin <slavins at bigfraud.org>: > > On 12 Dec 2015, at 6:14pm, Cecil Westerhof <cldwesterhof at gmail.com> wrote: > > > ?Not at the moment. But maybe that is a good idea.? > > With clauses like > > >>> WHERE used IS NOT NULL) AS Used > > >>> WHERE used IS NULL > > It should transform the work done. >
?Here http://www.tutorialspoint.com/sqlite/sqlite_indexes.htm it is said that you should not use an index on columns that use a high number of NULL values. At the moment that is true. So I should not use an Index?? -- Cecil Westerhof