Hi Ian,

> Thanks for the idea Martijn,
>
> Heres the stored procedure to do the job!
>
> CREATE PROCEDURE SYS_RECALC_SELECTIVITY
> returns (indexname char(31))
> AS
> begin
> for select rdb$index_name from rdb$indices into :indexname do
> begin
> execute statement 'set statistics index ' || :indexname;
> suspend;
> end
> end

Why are you making this procedure selectable?
(suspend)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com