Advertisement
econz

Firebird - Recalcula Índice de Seletividade dos Índices

Feb 10th, 2012
297
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. CREATE PROCEDURE SP_RECALCULA_SELETIVIDADE_INDICE
  2. AS
  3. DECLARE variable S VARCHAR(200);
  4. BEGIN
  5.  
  6. FOR SELECT RDB$INDEX_NAME FROM RDB$INDICES INTO :S DO
  7. BEGIN
  8.     S = 'SET statistics INDEX ' || s || ';';
  9.     EXECUTE STATEMENT :s;
  10. END
  11.  
  12. SUSPEND;
  13.  
  14. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement