Re: No future for DB2 - slightly off-topic, discusses what people are being taught at uni

Mark A wrote:

> The result is that many schemas have way too many indexes that will never be
> used, and of course invariably there are at least a few indexes missing.

While I have seen my fair share of under and over indexed tables I am a wondering why this concern about slowing up an insert. Rarely is the problem with an application's performance related to speed of inserts. Rather it is the speed to retrieval, SELECT, that is the issue and the focus on getting the data IN should not take precedence over getting it back out.

One can only insert a record one time. Likely the record will be queried many many times thereafter.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)