markd_mms wrote:

>--- 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
>
>
>
>

If I am not mistaken, something like (1/record count).

But how the querys works after the index statistics update ?

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br