Compute Statistics

PROMPT Cursor para la optimizacion de querys con COMPUTE STATISTICS
DECLARE
  CURSOR tabla IS
    SELECT TABLE_NAME
    FROM   USER_TABLES;
BEGIN
  FOR name IN tabla LOOP    
    EXECUTE IMMEDIATE 'ANALYZE TABLE ' || name.TABLE_NAME || ' COMPUTE STATISTICS'; 
  END LOOP;
END;
/