Kjell,

>> it's the other way around. If nulls are at the beginning then an index
>> can be used for "is null". And that's actually the state of affairs
>> (your case 2, I mean) I think.

KR> The same index COULD be used for "is not null" - use the index to find
KR> the first non-null record (skip all the nulls - should be easy using the
KR> idnex, or am I wrong?) and then return that record and all that follow
KR> until the end.

:-) this is exactly my enhancement proposal.

Ciao
--
Nando Dessena
http://www.flamerobin.org