Subject Re: Slow query help
Author markd_mms
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:
>
> select rdb$index_name, rdb$statistics from rdb$indices
>
> to update the statistics use this command:
> set statistics index <index_name>
>
> then commit and run again
> to see the difference.

PK_ITEM shows 0.000 before and after i run that. most of them show
0.000, there's 2 0.001's, 2 0.333's and 1 0.500 out of 25 indexes.
what kind of figures should i be seeing?

mark