Re: Performance effect of adding a new index

Sam wrote:
> Hi there,
> I have a table with about 10-20 insert per minutes and it can carry up to
> 500,000 records, except the primary key this table doesn't have any index,
> I need to make some reports based on a field that's System Date, this report
> shows in a web interface and run a few times per day,
> I heard that adding index on table with lot's of insert downgrade the insert
> performance,

At thousands of inserts per second I'd start being concerned.

-- 
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