I designing clustered column store indexed fact tables.

Later on many new columns might be added to these currently ~90 columns tables.

How adding new nullable column is affected by the size (number of rows) of the table? Is it a metadata only operation, or some data reorganization goes on under the hood which i need to take into account?

  • Roughly how many rows are in the table?
    – J.D.
    Jan 27 at 12:54
  • @J.D. 300-400 million rows.
    – Avi
    Jan 28 at 8:59


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.