Re: Beginner help needed in database design

Mark A wrote:

>>>The biggest problem is usually that too many indexes are created.
>>
>>That certainly seems to be true with commercial applications but
>>the exact opposite with in-house development. The rarest thing of
>>all is indexes created after development based upon someone actually
>>running the application and tuning against a realistic load.
>>--
>>Daniel A. Morgan

> 
> 
> 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
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)