On Tue, 3 May 2016 08:45 David G. Johnston, <david.g.johns...@gmail.com> wrote:
> I am not sure, but I think if the size of index is very huge and you >> suspect they are not being used, you might want to check the bloats >> percentage in the index. If this is true, perhaps a reindex might help. >> > > If they aren't being used just drop them. Its when they are used and get > bloated that you are in trouble. > Yes you are right. My bad. It is when they are bloated and being used by planner, the scans will be slower. > > There are recipes for bloat calculation out there that are worth > investigating. > > > David J. > > -- -- Best Regards Sameer Kumar | DB Solution Architect *ASHNIK PTE. LTD.* 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533 T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com