> > From: Haydies [mailto:[EMAIL PROTECTED] > Sent: Monday, September 15, 2003 11:19 AM > To: [EMAIL PROTECTED] > Subject: Re: Select distinct speed on an indexed column > > > Its a compound key, they are always slow. I would imagin you will need to > seriously redesign your database to speed that up. I'm not 100% sure how the > index is stored, but it would be some what pointless if it was individual > field values. Its like haveing "field1field2feild3field4field5" so that a > single comparison of the values tells you if its unique. You might be able > to speed it up by putting a secondary index on the first field....
Hmm... Well I tried adding and an additional index and that did not change the query speed. > > I'm curious as to why any one would design a database with that many feilds > in the primary key? Maybe its me but that would just be wrong. I'm not to > happy when I have 2 fields in the primary key.... I don't know. It's really out of my control. Maybe it's a Telecom thing. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
