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
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

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