| Subject | Re: What the problem with the optimizer and my SQL? |
|---|---|
| Author | emb_blaster |
| Post date | 2009-02-02T16:49:34Z |
--- In firebird-support@yahoogroups.com, Dimitry Sibiryakov <sd@...>
wrote:
Refresh the index statistics solved the problem. This is not
automaticaly maded by FB? ThereĀ“s a way to I do this in all index of
the DB by SQL? Or I had to do one by one by "SET STATISTICS INDEX name"?
wrote:
>Gotcha!!! Thanks!
> > Can anyone say why I needed to do this in this case? It is not a very
> > complex Select it is?
>
> Did you try to refresh index statistics?
>
> SY, SD.
>
Refresh the index statistics solved the problem. This is not
automaticaly maded by FB? ThereĀ“s a way to I do this in all index of
the DB by SQL? Or I had to do one by one by "SET STATISTICS INDEX name"?