Re: Procedure for adding a column

By "quite a long time" I meant at least a few hours.
-David

ron(dot)l(dot)johnson(at)cox(dot)net (Ron Johnson) wrote in message news:<1065896503(dot)24193(dot)53(dot)camel(at)haggis>...
> On Thu, 2003-10-09 at 11:05, David Shadovitz wrote:
> > I need to add a column to a table. This table holds several thousand
> > records, has several indexes, and serves as the parent table to a few
> > child tables.
> >
> > When I've done this in the past, it has taken quite a long time for
> > the ALTER TABLE command to complete.
> >
> > So, what is the correct procedure for adding a column? Drop the
> > indexes, add the column, and recreate the indexes?
>
> Can you be more explicit about "quite a long time".
>
> -----------------------------------------------------------------
> Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
> Jefferson, LA USA