title: Add new id column and fill incremental value to already existing table
body: <p>I need to add an id column to my table which is having around 500cr rows and update it with  incremental value. Please suggest what is the best way of doing it. 
  I tried running a query to update the value and store in new table but the query failed after 6 hrs saying timeout. Please help.</p>