| Subject | Re: [firebird-support] Order by slows down query (FB 2.5 SC on Linux 64 bits) |
|---|---|
| Author | Stefan Sinne |
| Post date | 2011-05-04T09:22:46Z |
Hello Mark.
We are doing a backup/restore every weekend. I think on restoring the statistics are recalculated
and should be up to date.
Thanks,
Stefan
El 04/05/2011 9:49, Mark Rotteveel escribió:
We are doing a backup/restore every weekend. I think on restoring the statistics are recalculated
and should be up to date.
Thanks,
Stefan
El 04/05/2011 9:49, Mark Rotteveel escribió:
>[Non-text portions of this message have been removed]
> Have you updated the statistics on the indices of your database. Try and see if that improves things.
>
> Mark
> --
>