Subject Re: [firebird-support] Index Selectivity maintenance
Author Martijn Tonies
Hi Ian,

> I'm just wondering what is the best way to automatically
> recalculate the index selectivity. I know that a backup and restore
> will do this but I'm after doing it with no downtime about once a
> month.
> Is there any way to do a global selectivity recalculation through
> isql, gfix or similar?

Using "SET STATISTICS" will do the same.

You have to do this for each index, but with the new EXECUTE
STATEMENT in a stored procedure, you don't even have to
write a client app for this :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions