Re: SET EXPLAIN - why are INSERT costs high???

David K. Killough wrote: [SNIP] > need to reduce these costs before they will tune our database. I don't > think it is possible. I don't think the high costs represent a failure to > optimize. I am very sure about this. Does anybody know the scoop. If so, > is there any reference in the Informix documentation that I can go to. It > seems like indexes should have some impact on the efficiency of doing > inserts. Does SET EXPLAIN help cost this at all????? > thanks, dave k Indexes will increase the cost of an INSERT since more work needs to be done, each of the indexes has to be updated in addition to the table. Art S. Kagel