Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE SP_RECALCULA_SELETIVIDADE_INDICE
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement