• The same principle 'probably' applies

    i.e. Create table and clustered index, populate IN CLUSTERED INDEX ORDER, create additional indexes

    But...

    (1) With this much data you may well be sorting it first unless you are getting it straight out of another indexed tables (e.g. aggregation). If you have a sort step you'll need to test whether sorting is more intensive than creating the clustered index afterwards. It may well be.

    (2) With this much data there may be a better way of doing this - e.g. only populating changes - you'd have to write logic for this

    (3) With more complex requirements, as previous posters have said, you should test different techniques and see what works best - There are lots of potential differences vetween environments.

    There is no 'best' way of doing things which always applies!

    🙂

    .