[sqlite] Exclude NULL from index

2016-04-14 Thread Cecil Westerhof
2016-04-14 19:49 GMT+02:00 Dominique Devienne : > On Thu, Apr 14, 2016 at 7:48 PM, Cecil Westerhof > wrote: > > > If I would have a table where a lot of values are NULL. Would it be > > possible to exclude those records from the index? I would only search > for a > > certain value not for NULL. O

[sqlite] Exclude NULL from index

2016-04-14 Thread Dominique Devienne
On Thu, Apr 14, 2016 at 7:48 PM, Cecil Westerhof wrote: > If I would have a table where a lot of values are NULL. Would it be > possible to exclude those records from the index? I would only search for a > certain value not for NULL. Or is it the default that they are excluded? https://www.sqli

[sqlite] Exclude NULL from index

2016-04-14 Thread Cecil Westerhof
If I would have a table where a lot of values are NULL. Would it be possible to exclude those records from the index? I would only search for a certain value not for NULL. Or is it the default that they are excluded? -- Cecil Westerhof