-
邝月
发布于 2008-08-16 21:10
-
收藏
select case when status='UNUSABLE' then'alter index '||owner||'.'||index_name||' rebuild online compute statistics;'when to_number(degree)>1 then'alter index /* '||degree ||' */'||owner||'.'||index_name||' noparallel;'end casefrom..