Forum OpenACS Development: Re: Tool to find missing Oracle indexes?

Collapse
Posted by Dirk Gomez on

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.

Collapse
Posted by Jeff Davis on
you should also check that the foreign keys are indexed
( http://osi.oracle.com/~tkyte/unindex/index.html ) since
that can have a pretty big impact on dml.