Estimate for altering a table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Estimate for altering a table

  1. #1
    Join Date
    Feb 2005
    Posts
    10

    Estimate for altering a table

    Hi ,

    I need to provide an estimate of Migrating application to the next version.

    This migration involves lot of changes in the Tables. So i need to find out how much time it takes.

    So can u please help me with ur experience.

    1. How much time will it take to add a column or one or more columns to a big Table.

    ( please tell me with ur experience on the no. of rows and the time taken to add a column or more)


    2. How long to delete a column

    3. Have u experience any case where creating a new table is faster instead of altering the Table if we are going to add more than 10 rows

    Please do help me out.
    Thanks

  2. #2
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    You really have to test it. Either on a full size system or a smaller subset and extrapolate the results.

    You'll look a right spoon when its taking much longer that you said and your excuse is "some guys on the interfloppy said it would be much quicker than this"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width