[thelist] Updating a BIG table with a few indexes...

Matt Warden mwarden at gmail.com
Wed Sep 5 10:54:21 CDT 2007

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

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list