[size=large]这个问题的原因是索引失效,[/size]
[size=large]通过[/size]
[size=large] 可以构建重建索引的sql语句[/size]
select index_name ,status from user_indexes where Status = 'UNUSABLE'
[size=large]可以查询出失效的索引[/size]
[size=large]通过[/size]
select 'alter index ' || index_name || ' rebuild;' from user_indexes where Status = 'UNUSABLE'
[size=large] 可以构建重建索引的sql语句[/size]