question

anup8484 avatar image
anup8484 asked

Indexes on 40 Billion record table

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.

indexesperformance-tuning
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·

Schema for the table? If there are other fields, it might complicate issues.

What version (& edition) of SQL Server are you on?

What's the usage pattern for this table?

What's the underlying hardware / storage? How much memory?

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.