6 Replies Latest reply on Apr 25, 2014 3:26 PM by user5716448

    Change datatype on column on large table quickly




      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.