On 9/5/07, Tris <beertastic at gmail.com> wrote: > We have 8 million records on our users table. > > We want to add 8 indexes to 7 of the 17 columns. we have 2 already... > to do so is taking 9+ hours... > > is there an easy (well, quick way) to change a table structure, > without taking so long? Definitely should not be taking that long. How exactly are you adding these indexes? What kind of indexes are they? -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.