Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
egemen_ates
Yak Posting Veteran
76 Posts |
 Posted - 2012-02-23 : 08:22:57
|
| i checked index fragmentation,Results are as shown below.IndexName ,ObjectName ,AvgFragmentation_in_percentNCL_COMPANY_PERIOD_2,COMPANY_PERIOD ,87.5impose a command to rebuild and again check index fragmentation.IndexName ObjectName AvgFragmentation_in_percentNCL_COMPANY_PERIOD_2 COMPANY_PERIOD 75How can i lower index fragmentation below five?thnk you |
|
|
|
|
|
Index Fragmentation