SET TERM ^ ;
CREATE PROCEDURE MAINTENANCE_SELECTIVITY
AS
DECLARE VARIABLE S VARCHAR(200);
BEGIN
FOR select RDB$INDEX_NAME FROM RDB$INDICES INTO :S DO
BEGIN
S = 'SET statistics INDEX ' || s || ';';
EXECUTE STATEMENT :s;
END
SUSPEND;
END
^
SET TERM ; ^
Tomado de: http://www.dotnetfirebird.org/blog/2005/03/improving-query-performance-through.html
No hay comentarios:
Publicar un comentario