select 'ANALYZE INDEX '|| object_name ||' estimate STATISTICS sample 25 percent;' from user_objects where object_type='INDEX'