SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 08:42 AM
| ||||
| ||||
 RE: Index problem PeopleSoft is notorious for *delivering* these kinds of unique indexes... Self-inflected, bloated unique indexes,,,well, one never knows why. -----Original Message----- From: owner-informix-list@iiug.org [mailto  wner-informix-list@iiug.org] On Behalf Of Obnoxio The ClownSent: Thursday, July 07, 2005 3:40 AM To: hsteinestel@web.de Cc: informix-list@iiug.org Subject: Re: Index problem hsteinestel@web.de said: > > 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. A unique index across SIX COLUMNS??????????????????????????????????????????? ?????????????????????????????????????????????????? ????????????????????????????????????? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere. sending to informix-list sending to informix-list      |
Linear Mode
