6 Replies Latest reply: Apr 25, 2014 10:05 AM by Mark D Powell RSS

    Change datatype on column on large table quickly

    user5716448

      Hi,

       

      We have a table approx 500 million rows and added column to it (empty).

       

      Tried dropping column but very slow, changing datatype also very slow (taking over 10 mins so killed).

       

      Test system - how can we either drop it or change column type quickly.

       

      Thanks