Search

OakieTags

Who's online

There are currently 0 users and 34 guests online.

Recent comments

Affiliations

When unused – isn’t.

So we recently reviewed a table with no fewer than 23 indexes on it. A combination of alter index… monitoring usage and reviewing DBMS_HIST_SQL_PLAN for plans that referenced the indexes found 8 indexes that were never used. As this table is also heavily updated we removed the indexes identified as unused. This was, fortunately, a […]