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

[Matt Warden]

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.