Find Oracle duplicated index
Posted on 2013-06-10
I come from MS SQL server background and usually as part of the maintenance operation we usually find duplicated index and drop one of them, and also we can combine index so that we can save more disk space as we drop some and combine some index.
do Oracle use this kind of concept?
Any script used to find duplicated index?
if Oracle find indexs both the same column, when Oracle load balance the use of both index so that index contention can be reduced ?