Subject | Re: not null in statement very slow |
---|---|
Author | sascha_luttmann |
Post date | 2004-03-10T15:27:28Z |
--- In firebird-support@yahoogroups.com, "Arno Brinkman"
<firebird@a...> wrote:
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
<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