prevent Index Fragmentation.

experts,

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

Thanks,

Lynn
yrcdba7Asked:
Who is Participating?
 
lluddenConnect With a Mentor Commented:
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.
0
 
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.
0
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.

All Courses

From novice to tech pro — start learning today.