Re: [sqlite] index with NULL values

Good stuff! Is this in the wiki somewhere? On 6/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Adler, Eliedaat" <[EMAIL PROTECTED]> wrote: > Hi, > > I want to add an index on a sparsely populated column - > i.e. for most rows the column is null. > > 1. Would this index be very compact?

[sqlite] index with NULL values

Hi, I want to add an index on a sparsely populated column - i.e. for most rows the column is null. 1. Would this index be very compact? i.e. only include "set" rows. 2. Could this index also help select NULL entries? Thanks, Eliedaat Adler