Home > Archive > Oracle Server > July 2005 > Re: No future for DB2 - slightly off-topic, discusses what people









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: No future for DB2 - slightly off-topic, discusses what people
DA Morgan

2005-07-31, 8:23 pm

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@x.washington.edu
(replace x with u to respond)
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com