Subject | Re: Slow query help |
---|---|
Author | markd_mms |
Post date | 2005-12-01T23:55:10Z |
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:
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
<iblist@t...> wrote:
>PK_ITEM shows 0.000 before and after i run that. most of them show
> 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.
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