Forum OpenACS Development: Re: Tool to find missing Oracle indexes?
How would you determine which indexes are missing? That's tough problem, right?
E. g. full-table scans are not necessarily evil and indexes accesses are not necessarily beneficial. Over-indexing in fact hurts, both on data insertion and update, and maybe even on retrieval.
Take statspack snapshots and tackle the worst queries day after day.