This shows you the differences between two versions of the page.
kurs:analyze_indices_index [2014/09/10 21:22] |
kurs:analyze_indices_index [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | select 'ANALYZE INDEX '|| object_name ||' estimate STATISTICS sample 25 percent;' from user_objects where object_type='INDEX' |