Subject Re: [ib-support] Tool for Recreating indexes
Author Martijn Tonies
Hi Guido,

> Does anybody know a tool for recreating all indexes of a db or just
> recompute selectivity off all indexes ?

InterBase Workbench and Firebird Workbench both can do that.

Alternatively, you can easily do it yourself too.

select 'set statistics index ' || rdb$index_name || ';'
from rdb$indices

And get the output text as a script.

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase

Firebird Workbench - the developer tool for Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."