--- In firebird-support@yahoogroups.com, "sascha_luttmann" wrote:

> --- In firebird-support@yahoogroups.com, "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
problems?).

Set