Index Rebuild or Index Defrag?

I have DBs that have indexes that are fragmented in various levels from 30% to 99% because index maintenance was never scheduled/ created.  I know that it is easier to INDEXDEFRAG than to Rebuild the INDEX (Less time and no long term locks on the table), but there must me a specific point where rebuilding would be better than tryig to defrag the index.  (I know that rebuilding would need to be done in non-production hours or late at night).  But I want to set up a process that checks the fragmentation of an index and if the %of fragmentations is over a specific amount, set that index for rebuilding and if it is less than a specifi % set the index for defraging.   Does anyone have an idea where / what that % might be?  (Lets use a simple index of one column with 500K records as an example).

Thanks in advance
blbergerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
St3veMaxConnect With a Mentor Commented:
Some say....That if the fragmentation is > 30% the re-index; otherwise Rebuild.

HTH
0
 
SQL_SERVER_DBACommented:
0
 
blbergerAuthor Commented:
Thank you for a direct answer.  I have read the article pointed out by the other response, but it did not give me the threshold value.
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.