Subject Re: not null in statement very slow
Author Svein Erling
--- In, "sascha_luttmann" wrote:
> --- In, "Arno Brinkman" wrote:
> Hi,
> > Then you've a index on DELDATE and also you've many NULLs in that
> > table, right?
> Yes there's an index on DELDATE but there are only 5 NULLs of about
> 25000 records...

Then you must have lots of entries with the same value for DELDATE (i.
e. the index for ID is pretty selective, whereas the index for DELDATE
isn't - or maybe it is a descending index or duplicate indexes causing