Subject Re: not null in statement very slow
Author sascha_luttmann
--- In firebird-support@yahoogroups.com, "Arno Brinkman"
<firebird@a...> wrote:
> Could you give the statistics info from index DELDATE ?

Yes sure..

Index MOV_ORDP_DELDATE (5)
Depth: 2, leaf buckets: 39, nodes: 25772
Average data length: 0.00, total dup: 25159, max dup: 17572
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 38

HTH,

Sascha