Hi guys, I have a heap table with 40 billion records and its on the grain of Item,store,week. The table is partitioned on week and has a total of 104 weeks. I need to create a clustered index on Item,store week. What is the best option to go about it ? What would be the approx time for index creation on this dataset ? Will partition switching from a heap table ( Table a) to a truncated index created table ( table b) help in any way? or would it eventually result in fragmentation.
