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

Collapse
3: Re: Tool to find missing Oracle indexes? (response to 1)
Posted by Dirk Gomez on 10/31/03 11:46 AM

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
4: Re: Tool to find missing Oracle indexes? (response to 3)
Posted by Jeff Davis on 10/31/03 01:14 PM
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.