Index strategy
From: Helma <helma.vinke_at_hotmail.com>
Date: Wed, 2 Jun 2010 05:49:03 -0700 (PDT)
Message-ID: <c426f687-ac26-4525-8774-79974d29f3e8_at_j9g2000vbp.googlegroups.com>
I now work at a shop where the developers over the years have added many (random) indexes on the database, and (still) having problems with performance. I see many sql-statements coming by that use suboptimal indexes, I think it would be a good idea to mass-review the sql and indexes, increasing the quality of the indexes and reduce the 'overindexing' of the DB. Seniors! I assume you have encountered this situation before. How to efficiently deal with such situation?
Date: Wed, 2 Jun 2010 05:49:03 -0700 (PDT)
Message-ID: <c426f687-ac26-4525-8774-79974d29f3e8_at_j9g2000vbp.googlegroups.com>
I now work at a shop where the developers over the years have added many (random) indexes on the database, and (still) having problems with performance. I see many sql-statements coming by that use suboptimal indexes, I think it would be a good idea to mass-review the sql and indexes, increasing the quality of the indexes and reduce the 'overindexing' of the DB. Seniors! I assume you have encountered this situation before. How to efficiently deal with such situation?
Oracle 10g Received on Wed Jun 02 2010 - 07:49:03 CDT