At 09:26 AM 1/10/2003 +0000, Michael Vilhelmsen
<Michael.Vilhelmsen@...> wrote:

>Update a record ... update on 12 tables ... update on another table
>... update on 2 other tables (through) trigges.
>... insert somewhere between 8 and 40 records in a table with
>somewhere around 40 index on.
>
>Now My customer complains aboout speed.
>I have recently created those 40 index. Before there was only 4.
>
>Could those 40 index cause the system to slow down significantly ?

Yes. Though I'd also worry about updating 15 tables to record
a sale, especially if you have indexes that are not particularly
selective. You're setting yourself up for garbage collection
problems.


Regards,

Ann
www.ibphoenix.com
We have answers.