Re: SELECT statement efficiency question

Charles Hooper wrote:

> I have also seen the statement written in books, blogs, and articles
> stating that having too many indexes on tables causes performance
> problems, essentially that a table update that would have required one
> I/O is turned into one I/O plus three or four I/Os per index (or maybe
> it was two to three I/Os per index).

And if you want to see it really get ugly ... add a bunch of indexes and rollback the transaction.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org