Subject | Re: What the problem with the optimizer and my SQL? |
---|---|
Author | emb_blaster |
Post date | 2009-02-02T19:35:20Z |
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;
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"?