Re: Help

Comp Services wrote: > Has anyone got the problem of excessively slow deletes in Informix > 6.03 running on Motorola AIX, even after having removed most > constraints and indexes. Without seeing the table and the delete statement, aldn lacking a specific duration of the delete, it's hard to tell. However, usual culprits are: - Failure to run UPDATE STATISTICS. - Excessive number of indexes and constraints (which you say you have reduced.) - The best index for optimization had been deleted (or not created) - Lock mode on the table is PAGE, which which subjects you to deadlock or other interference from other users. - The engine - did you mean 6.03 ENGINE? Running the delete with SET EXPLAIN ON might give you a clue. > If so, why and does anybody know how to get around it (without adding > an extra field in the table). Why would adding an extra field help? -- -- Jake (Retrospectively realizes there is no future in hindsight) +------------------------------------------------------------+ | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+