| Subject | Re: Index Selectivity maintenance | 
|---|---|
| Author | Ian A. Newby | 
| Post date | 2004-03-09T15:50:20Z | 
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
Regards
Ian Newby
            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
Regards
Ian Newby