2020-02-16 标签:dba,indexes,视图,性能,分析,select,case,when,status,unusable,alter,index,owner,n,ame,rebuild,online,compute,statistics,umber

select case when status='UNUSABLE' then'alter index '||owner||'.'||index_name||' rebuild online compute statistics;'when to_number(degree)>1 then'a