• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • Last Modified:

Cluster indexing in large fact table

What is the best approach in implimenting cluster index on a table which having large volumns of data? I'm looking at the answer in term of effective Data insert/Retrieval without effecting to business users.
1 Solution
Appart with @cy_hung mentioned link

Clustered Indexes some Things You Need to Know

A. Always use a clustered index on an OLTP database table.
B. If you consider using a clustered index on a uniqueidentifier column:
Test your solution in a stress test environment.
Rebuild indexes regularly.

Also go through following link of article


 the most desirable attributes of a clustered index: narrow, unique, static, and ever-increasing. I've explained what each attribute is and why each is important. I've also presented the basics of B-tree structure for clustered and non-clustered indexes. The topic of "indexing strategy" is vast topic and we've only scratched the surface. Beyond what I presented in this article, there are also many application-specific considerations when choosing a clustering key, such as how data will be accessed and the ability to use the clustered index in range-scan queries. As such, I'd like to stress that the attributes discussed in this article are not concrete rules but rather time-proven guidelines. The best thing to do if you're not sure if you've chosen the best clustering key is to test and compare the performance of different strategies.
keplanAuthor Commented:
excellent article about Clustered index and Heaps table
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now