Subject | Re: Index Selectivity maintenance |
---|---|
Author | Ian A. Newby |
Post date | 2004-03-09T16:10:55Z |
Hi Martijn,
Only so I could see the list of indexes rebuilt.
Its really going to be
CREATE PROCEDURE SYS_RECALC_SELECTIVITY
AS
declare variable indexname char(31);
begin
for select rdb$index_name from rdb$indices into :indexname do
begin
execute statement 'set statistics index ' || :indexname;
end
end
regards
Ian
Only so I could see the list of indexes rebuilt.
Its really going to be
CREATE PROCEDURE SYS_RECALC_SELECTIVITY
AS
declare variable indexname char(31);
begin
for select rdb$index_name from rdb$indices into :indexname do
begin
execute statement 'set statistics index ' || :indexname;
end
end
regards
Ian