> > Case tools (ERWin, PowerDesigner, etc) tend to generate too many indexes
for
> > custom in-house applications.
>
> Interesting. I haven't worked with PowerDesigner but I do a lot
> of work with ERwin and while it has this nasty habit of wanting
> to build more triggers than I can imagine I can't recall it ever,
> once, building an index not associated with a constraint.
> --
> Daniel A. Morgan
A foreign key constraint does not necessarily need an index if the
cardinality is low and the parent table is not deleted or updated very
frequently. This situation alone can produce about double the number of
needed indexes in most systems I have seen.
Received on Mon Jan 31 2005 - 20:15:58 CST
