Index problem

Posted in 2005

hsteinestel@web.de — 7 Jul 2005 00:20:51 -0700 — source: Usenet: comp.databases.informix

Hello, we have a database table with 7 columns and approximately 10 million rows. There is a unique index on 6 columns. The customer with the 10 million rows had problems with his system because the INSERTs were very slow. Yesterday, his database administrators added 2 new indizes.. Now, the perfomance is much better. Why?? I always thought a unique index is the best way to optimize the DB. Thanks, Holger