ÿþindex_id name avg_fragmentation_in_percent ----------- -------------------------------------------------------------------------------------------------------------------------------- ---------------------------- 1 NameValuePair_Georgian_Modern_Sort_CI_AS_CI 0 2 NameValuePair_Georgian_Modern_Sort_CI_AS_NoListId 0 3 NameValuePair_Georgian_Modern_Sort_CI_AS_MatchUserData 0 1 DatabaseInformation_Name 0 1 Groups_PK 83,3333333333333 2 Groups_Title 50 3 Groups_Id 0 4 Groups_DLAlias 0 1 Deps_DocToDep 72 2 Deps_DepToDoc 89,6551724137931 1 NameValuePair_German_PhoneBook_CI_AS_CI 0 2 NameValuePair_German_PhoneBook_CI_AS_NoListId 0 3 NameValuePair_German_PhoneBook_CI_AS_MatchUserData 0 1 GroupMembership_GroupId 50 2 GroupMembership_MemberId 50 1 NameValuePair_Greek_CI_AS_CI 0 2 NameValuePair_Greek_CI_AS_NoListId 0 3 NameValuePair_Greek_CI_AS_MatchUserData 0 1 AllDocs_PK 67,2480620155039 1 AllDocs_PK 0 2 Docs_IdLevelUnique 99,0716496072364 1 Roles_PK 81,8181818181818 2 Roles_Title 50 1 NameValuePair_Hebrew_CI_AS_CI 0 2 NameValuePair_Hebrew_CI_AS_NoListId 0 3 NameValuePair_Hebrew_CI_AS_MatchUserData 0 1 NameValuePair_Hindi_CI_AS_CI 0 2 NameValuePair_Hindi_CI_AS_NoListId 0 3 NameValuePair_Hindi_CI_AS_MatchUserData 0 1 RoleAssignment_PricipalId 93,3333333333333 2 RoleAssignment_NCI 95,2380952380952 1 NameValuePair_Hungarian_CI_AS_CI 0 2 NameValuePair_Hungarian_CI_AS_NoListId 0 3 NameValuePair_Hungarian_CI_AS_MatchUserData 0 1 NameValuePair_Hungarian_Technical_CI_AS_CI 0 2 NameValuePair_Hungarian_Technical_CI_AS_NoListId 0 3 NameValuePair_Hungarian_Technical_CI_AS_MatchUserData 0 1 NameValuePair_Icelandic_CI_AS_CI 0 2 NameValuePair_Icelandic_CI_AS_NoListId 0 3 NameValuePair_Icelandic_CI_AS_MatchUserData 0 1 NameValuePair_Japanese_CI_AS_CI 0 2 NameValuePair_Japanese_CI_AS_NoListId 0 3 NameValuePair_Japanese_CI_AS_MatchUserData 0 1 NameValuePair_Japanese_Unicode_CI_AS_CI 0 2 NameValuePair_Japanese_Unicode_CI_AS_NoListId 0 3 NameValuePair_Japanese_Unicode_CI_AS_MatchUserData 0 1 AllDocStreams_CK 92,5423728813559 1 AllDocStreams_CK 0 2 AllDocStreams_DeleteTransactionIdIdLevelUnique 99,0506329113924 3 AllDocStreams_IdLevelUnique 98,5759493670886 4 AllDocStreams_SiteIdId 99,3670886075949 1 NameValuePair_Korean_Wansung_CI_AS_CI 0 2 NameValuePair_Korean_Wansung_CI_AS_NoListId 0 3 NameValuePair_Korean_Wansung_CI_AS_MatchUserData 0 1 NameValuePair_Korean_Wansung_Unicode_CI_AS_CI 0 2 NameValuePair_Korean_Wansung_Unicode_CI_AS_NoListId 0 3 NameValuePair_Korean_Wansung_Unicode_CI_AS_MatchUserData 0 1 NameValuePair_Latin1_General_CI_AS_CI 66,6666666666667 2 NameValuePair_Latin1_General_CI_AS_NoListId 50 3 NameValuePair_Latin1_General_CI_AS_MatchUserData 50 1 NameValuePair_Latvian_CI_AS_CI 0 2 NameValuePair_Latvian_CI_AS_NoListId 0 3 NameValuePair_Latvian_CI_AS_MatchUserData 0 1 AllDocVersions_PK 96,6346153846154 1 AllDocVersions_PK 0 1 NameValuePair_Lithuanian_CI_AS_CI 0 2 NameValuePair_Lithuanian_CI_AS_NoListId 0 3 NameValuePair_Lithuanian_CI_AS_MatchUserData 0 1 NameValuePair_Lithuanian_Classic_CI_AS_CI 0 2 NameValuePair_Lithuanian_Classic_CI_AS_NoListId 0 3 NameValuePair_Lithuanian_Classic_CI_AS_MatchUserData 0 1 Links_Forward 24,5188397939821 1 Links_Forward 0 2 Links_Backward 91,7156077593878 1 NameValuePair_Traditional_Spanish_CI_AS_CI 0 2 NameValuePair_Traditional_Spanish_CI_AS_NoListId 0 3 NameValuePair_Traditional_Spanish_CI_AS_MatchUserData 0 1 NameValuePair_Modern_Spanish_CI_AS_CI 0 2 NameValuePair_Modern_Spanish_CI_AS_NoListId 0 3 NameValuePair_Modern_Spanish_CI_AS_MatchUserData 0 1 NameValuePair_Polish_CI_AS_CI 0 2 NameValuePair_Polish_CI_AS_NoListId 0 3 NameValuePair_Polish_CI_AS_MatchUserData 0 1 NavNodes_PK 94,6428571428571 1 NavNodes_PK 0 2 NavNodes_AltPK 94,7368421052632 3 NavNodes_DocId 95,2380952380952 1 RecycleBin_PK 0 2 RecycleBin_TransactionId 0 3 RecycleBin_ListTransactionId 0 1 NameValuePair_Romanian_CI_AS_CI 0 2 NameValuePair_Romanian_CI_AS_NoListId 0 3 NameValuePair_Romanian_CI_AS_MatchUserData 0 1 Sites_Id 0 1 Sites_Id 0 1 NameValuePair_Slovak_CI_AS_CI 0 2 NameValuePair_Slovak_CI_AS_NoListId 0 3 NameValuePair_Slovak_CI_AS_MatchUserData 0 1 NameValuePair_Slovenian_CI_AS_CI 0 2 NameValuePair_Slovenian_CI_AS_NoListId 0 3 NameValuePair_Slovenian_CI_AS_MatchUserData 0 1 NameValuePair_Thai_CI_AS_CI 0 2 NameValuePair_Thai_CI_AS_NoListId 0 3 NameValuePair_Thai_CI_AS_MatchUserData 0 1 NameValuePair_Turkish_CI_AS_CI 0 2 NameValuePair_Turkish_CI_AS_NoListId 0 3 NameValuePair_Turkish_CI_AS_MatchUserData 0 1 NameValuePair_Ukrainian_CI_AS_CI 0 2 NameValuePair_Ukrainian_CI_AS_NoListId 0 3 NameValuePair_Ukrainian_CI_AS_MatchUserData 0 1 NameValuePair_Vietnamese_CI_AS_CI 0 2 NameValuePair_Vietnamese_CI_AS_NoListId 0 3 NameValuePair_Vietnamese_CI_AS_MatchUserData 0 1 PageUrlID_FK 96,8354430379747 1 PageUrlID_FK 0 2 ListId_FK 98,6666666666667 3 WebParts_PK 99,2 4 WebParts_UserID 96,8421052631579 1 SiteVersions_PK 0 1 Webs_PK 93,9759036144578 1 Webs_PK 0 2 Webs_SiteIdParent 80 3 Webs_FUAWI 0 4 Webs_MU 66,6666666666667 5 Webs_CMU 75 6 Webs_NPWI 0 1 WebPartLists_PageUrlID 97,9057591623037 2 WebPartLists_ListId 97,8723404255319 1 Features_PK 93,9393939393939 0 NULL 0 1 EventCache_Id 94,0860014196585 1 EventCache_Id 0 2 EventCache_Time 1,34310134310134 3 EventCache_SiteId 1,2853470437018 4 EventCache_ListId 61,9017632241814 1 EventLog_Id 7,01463684065175 2 EventLog_SiteIdEventTime 19,1542288557214 1 EventSubsMatches_EventIdSubId 0 1 ImmedSubscriptions_SiteIdListIdItemId 0 2 ImmedSubscriptions_SiteIdWebIdUserId 0 3 ImmedSubscriptions_SiteIdUserIdSubId 0 4 ImmedSubscriptions_SiteIdWebUrlListUrl 0 1 Categories_DocId 0 2 Categories_CategoryId 0 1 WebCat_WebIdCategory 96,2962962962963 1 AllLists_PK 84,6994535519126 1 AllLists_PK 0 2 Lists_FullText 90,9090909090909 1 SchedSubscriptions_SiteIdNotifyFreqListIdItemId 0 2 SchedSubscriptions_SiteIdWebIdUserId 0 3 SchedSubscriptions_SiteIdUserIdSubId 0 4 SchedSubscriptions_SiteIdWebUrlListUrl 0 5 SchedSubscriptions_NotifyTimeUTC 0 1 HT_Setting_PK 0 1 Personalization_PK 0 2 Personalization_ZoneID 0 3 Personalization_UserID 0 1 HT_Cache_PK 0 1 WelcomeNames_PK 0 1 TimerLock_PK 0 1 AllUserData_Url 32,6607818411097 1 AllUserData_Url 0 2 AllUserData_PK 83,2185174979333 0 NULL 0 1 Workflow_PK 0 2 Workflow_IdUnique 0 3 Workflow_CreatedBy 0 4 Workflow_OnItem 0 5 Workflow_OnId 0 1 WorkflowAssociation_Id 85,7142857142857 1 WorkflowAssociation_Id 0 2 WorkflowAssociation_IdUnique 0 3 WorkflowAssociation_Parent 0 1 ScheduledWorkItems_OnDateType 0 2 ScheduledWorkItems_IdUnique 0 3 ScheduledWorkItems_OnId 0 4 ScheduledWorkItems_OnListKey 0 1 ComMd_SiteIdDocIdId 0 1 EventReceivers_ByTarget 94,2857142857143 2 EventReceivers_IdUnique 95,8333333333333 3 EventReceivers_ById 95,8333333333333 4 EventReceivers_ByContextObjectId 95,6521739130435 5 EventReceivers_ByContextCollectionId 95,6521739130435 1 NameValuePair_CI 0 2 NameValuePair_NoListId 0 3 NameValuePair_MatchUserData 0 1 ContentType_PK 88,8888888888889 1 ContentType_PK 0 1 NameValuePair_Albanian_CI_AS_CI 0 2 NameValuePair_Albanian_CI_AS_NoListId 0 3 NameValuePair_Albanian_CI_AS_MatchUserData 0 1 NameValuePair_Arabic_CI_AS_CI 0 2 NameValuePair_Arabic_CI_AS_NoListId 0 3 NameValuePair_Arabic_CI_AS_MatchUserData 0 1 AuditData_OnSiteOccurredEvent 0 1 AuditData_OnSiteOccurredEvent 0 2 AuditData_OnSiteItem 0 1 SiteQuota_SiteId 0 1 NameValuePair_Chinese_PRC_CI_AS_CI 0 2 NameValuePair_Chinese_PRC_CI_AS_NoListId 0 3 NameValuePair_Chinese_PRC_CI_AS_MatchUserData 0 1 pk_ContentTypeUsage 99,4936708860759 2 idx_ListOnContentTypeUsage 90,979381443299 1 NameValuePair_Chinese_PRC_Stroke_CI_AS_CI 0 2 NameValuePair_Chinese_PRC_Stroke_CI_AS_NoListId 0 3 NameValuePair_Chinese_PRC_Stroke_CI_AS_MatchUserData 0 1 NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_CI 0 2 NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_NoListId 0 3 NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_MatchUserData 0 1 BuildDependencies_Forward 80,7692307692308 2 BuildDependencies_Backward 73,0769230769231 0 NULL 0 0 NULL 0 1 NameValuePair_Chinese_Taiwan_Stroke_CI_AS_CI 0 2 NameValuePair_Chinese_Taiwan_Stroke_CI_AS_NoListId 0 3 NameValuePair_Chinese_Taiwan_Stroke_CI_AS_MatchUserData 0 1 CollationNames_Collation 0 1 AllUserDataJunctions_PK 80 1 NameValuePair_Croatian_CI_AS_CI 0 2 NameValuePair_Croatian_CI_AS_NoListId 0 3 NameValuePair_Croatian_CI_AS_MatchUserData 0 1 NameValuePair_Cyrillic_General_CI_AS_CI 0 2 NameValuePair_Cyrillic_General_CI_AS_NoListId 0 3 NameValuePair_Cyrillic_General_CI_AS_MatchUserData 0 1 NameValuePair_Czech_CI_AS_CI 0 2 NameValuePair_Czech_CI_AS_NoListId 0 3 NameValuePair_Czech_CI_AS_MatchUserData 0 1 UserInfo_PK 88,2352941176471 1 UserInfo_PK 0 2 UserInfo_SID 66,6666666666667 3 UserInfo_Login 75 4 UserInfo_Id 0 5 UserInfo_Email 50 6 UserInfo_SiteAdmin 0 7 UserInfo_Title 75 1 NameValuePair_Danish_Norwegian_CI_AS_CI 0 2 NameValuePair_Danish_Norwegian_CI_AS_NoListId 0 3 NameValuePair_Danish_Norwegian_CI_AS_MatchUserData 0 1 NameValuePair_Estonian_CI_AS_CI 0 2 NameValuePair_Estonian_CI_AS_NoListId 0 3 NameValuePair_Estonian_CI_AS_MatchUserData 0 1 Versions_PK 0 1 WebMembers_PK 80 1 NameValuePair_Finnish_Swedish_CI_AS_CI 0 2 NameValuePair_Finnish_Swedish_CI_AS_NoListId 0 3 NameValuePair_Finnish_Swedish_CI_AS_MatchUserData 0 1 Perms_PK 87,5 1 Perms_PK 0 2 Perms_WebId 83,3333333333333 3 Perms_Url 75 1 NameValuePair_French_CI_AS_CI 0 2 NameValuePair_French_CI_AS_NoListId 0 3 NameValuePair_French_CI_AS_MatchUserData 0 (253 row(s) affected)