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

prevent Index Fragmentation.


In an OLTP database (with a large number of inserts) what would be best and easiest action to prevent Index Fragmentation.


1 Solution
You need to determine why the fragmentation is happening.  Is it on every index or just a few?  You can reduce your Fill Factor to slow down the fragmentation rate, but it will still occur.  You can schedule maintenance jobs to rebuild your indexes.

Indexes on some data types (GUID) tend to fragment more easily.
Anthony PerkinsCommented:
>>what would be best and easiest action to prevent Index Fragmentation<<
Short answer:  You cannot.  Long(er) answer the best you can do is minimize fragmentation by choosing appropriate indexes and doing regular maintenance.
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

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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