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 Holger Steinestel said: > > Yes. What's wrong with that? It might well not be the most effective way of indexing a table. ;o) > Obnoxio The Clown schrieb: >> 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 =E0 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 > -- 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      |
Linear Mode
