Subject Re: What the problem with the optimizer and my SQL?
Author emb_blaster
Can anyone tell-me if this will run without damage my DB?

FOR
select RDB$INDEX_NAME from RDB$INDICES
where RDB$INDICES.RDB$SYSTEM_FLAG = 0
into :MY_INDEX
DO SET STATISTICS :MY_INDEX;


> Gotcha!!! Thanks!
>
> 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"?