Subject Re: [firebird-support] Big table and DB slowdowns
Author Ann W. Harrison
At 11:24 AM 8/31/2004, Jerome Bouvattier wrote:


>You will find hereafter some more tech infos. Let me know if I should
>provide more.
>
>
>Selectivities:
>
>
>PK_PRESENCE 1.887221401375427e-008
>PRESENCE_IDX1 0.02380952425301075
>PRESENCE_IDX2 5.623980541713536e-005
>PRESENCE_IDX3 7.386178822343936e-006
>PRESENCE_IDX4 1.887221401375427e-008
>PRESENCE_IDX5 1.601524388661346e-007
>RELATION_262 0.0001687478943495080
>RELATION_296 2.158489223802462e-006

Could you also provide an extract of a gstat showing the number
of duplicates on each of these indexes?

Thanks,


Ann