Database reference - DotNetNuke 6.2.1.253

DotNetNuke 6.2.1.253 -  indexes

Index overview

nametablesize (kb)description
PK_AffiliatesAffiliates0clustered, unique, primary key located on PRIMARY
PK_AnonymousUsersAnonymousUsers0clustered, unique, primary key located on PRIMARY
aspnet_Applications_Indexaspnet_Applications8clustered located on PRIMARY
PK__aspnet_A__C93A4C980B47A151aspnet_Applications16nonclustered, unique, primary key located on PRIMARY
UQ__aspnet_A__17477DE40E240DFCaspnet_Applications16nonclustered, unique, unique key located on PRIMARY
UQ__aspnet_A__3091033111007AA7aspnet_Applications16nonclustered, unique, unique key located on PRIMARY
aspnet_Membership_indexaspnet_Membership8clustered located on PRIMARY
PK__aspnet_M__1788CC4D29CC2871aspnet_Membership16nonclustered, unique, primary key located on PRIMARY
PK__aspnet_P__1788CC4C40AF8DC9aspnet_Profile0clustered, unique, primary key located on PRIMARY
aspnet_Roles_index1aspnet_Roles0clustered, unique located on PRIMARY
PK__aspnet_R__8AFACE1B4C214075aspnet_Roles0nonclustered, unique, primary key located on PRIMARY
PK__aspnet_S__5A1E6BC11D66518Caspnet_SchemaVersions8clustered, unique, primary key located on PRIMARY
aspnet_Users_Indexaspnet_Users8clustered, unique located on PRIMARY
aspnet_Users_Index2aspnet_Users16nonclustered located on PRIMARY
PK__aspnet_U__1788CC4D15C52FC4aspnet_Users16nonclustered, unique, primary key located on PRIMARY
aspnet_UsersInRoles_indexaspnet_UsersInRoles0nonclustered located on PRIMARY
PK__aspnet_U__AF2760AD51DA19CBaspnet_UsersInRoles0clustered, unique, primary key located on PRIMARY
PK_PackageAssembliesAssemblies8clustered, unique, primary key located on PRIMARY
PK_AuthenticationAuthentication8clustered, unique, primary key located on PRIMARY
IX_BannersBanners0nonclustered located on PRIMARY
IX_Banners_1Banners0nonclustered located on PRIMARY
PK_BannerBanners0clustered, unique, primary key located on PRIMARY
IX_ClassificationClassification0nonclustered located on PRIMARY
PK_VendorCategoryClassification0clustered, unique, primary key located on PRIMARY
PK_ContentItemsContentItems16clustered, unique, primary key located on PRIMARY
PK_Content_MetaDataContentItems_MetaData0clustered, unique, primary key located on PRIMARY
IX_ContentItems_TagsContentItems_Tags16nonclustered, unique located on PRIMARY
IX_ContentItems_Tags_TermIDContentItems_Tags16nonclustered located on PRIMARY
PK_ContentItems_TagsContentItems_Tags8clustered, unique, primary key located on PRIMARY
PK_ContentTypesContentTypes8clustered, unique, primary key located on PRIMARY
IX_CoreMessaging_MessageAttachments_MessageIDCoreMessaging_MessageAttachments0nonclustered located on PRIMARY
PK_CoreMessaging_MessageAttachmentsCoreMessaging_MessageAttachments0clustered, unique, primary key located on PRIMARY
IX_CoreMessaging_MessageRecipients_UserIDCoreMessaging_MessageRecipients0nonclustered located on PRIMARY
PK_CoreMessaging_MessageRecipientsCoreMessaging_MessageRecipients0clustered, unique, primary key located on PRIMARY
IX_CoreMessaging_Messages_SenderUserIDCoreMessaging_Messages0nonclustered located on PRIMARY
PK_CoreMessaging_MessagesCoreMessaging_Messages0clustered, unique, primary key located on PRIMARY
IX_CoreMessaging_NotificationTypeActionsCoreMessaging_NotificationTypeActions16nonclustered located on PRIMARY
PK_CoreMessaging_NotificationTypeActionsCoreMessaging_NotificationTypeActions8clustered, unique, primary key located on PRIMARY
IX_CoreMessaging_NotificationTypesCoreMessaging_NotificationTypes16nonclustered, unique located on PRIMARY
PK_CoreMessaging_NotificationTypesCoreMessaging_NotificationTypes8clustered, unique, primary key located on PRIMARY
PK_DashboardDashboard_Controls8clustered, unique, primary key located on PRIMARY
IX_DesktopModulePermissionDesktopModulePermission16nonclustered, unique, unique key located on PRIMARY
PK_DesktopModulePermissionDesktopModulePermission8clustered, unique, primary key located on PRIMARY
IX_DesktopModules_FriendlyNameDesktopModules16nonclustered located on PRIMARY
IX_DesktopModules_ModuleNameDesktopModules16nonclustered, unique, unique key located on PRIMARY
PK_DesktopModulesDesktopModules16clustered, unique, primary key located on PRIMARY
IX_EventLog_LogGUIDEventLog16nonclustered located on PRIMARY
PK_EventLogMasterEventLog16clustered, unique, primary key located on PRIMARY
IX_LogTypeKey_LogTypePortalIDEventLogConfig16nonclustered, unique located on PRIMARY
PK_EventLogConfigEventLogConfig16clustered, unique, primary key located on PRIMARY
PK_EventLogTypesEventLogTypes16clustered, unique, primary key located on PRIMARY
PK_EventQueueEventQueue16clustered, unique, primary key located on PRIMARY
IX_FileNameFiles16nonclustered, unique, unique key located on PRIMARY
IX_FilesFiles16nonclustered located on PRIMARY
IX_Files_UniqueIdFiles16nonclustered, unique, unique key located on PRIMARY
PK_FileFiles16clustered, unique, primary key located on PRIMARY
IX_FolderMappingsFolderMappings16nonclustered, unique, unique key located on PRIMARY
PK_FolderMappingsFolderMappings8clustered, unique, primary key located on PRIMARY
PK_FolderMappingsSettingsFolderMappingsSettings0clustered, unique, primary key located on PRIMARY
IX_FolderPermissionFolderPermission16nonclustered, unique, unique key located on PRIMARY
IX_FolderPermission_ModulesFolderPermission16nonclustered located on PRIMARY
IX_FolderPermission_PermissionFolderPermission16nonclustered located on PRIMARY
IX_FolderPermission_RolesFolderPermission16nonclustered located on PRIMARY
IX_FolderPermission_UsersFolderPermission16nonclustered located on PRIMARY
PK_FolderPermissionFolderPermission8clustered, unique, primary key located on PRIMARY
IX_FolderPathFolders16nonclustered, unique, unique key located on PRIMARY
IX_Folders_UniqueIdFolders16nonclustered, unique, unique key located on PRIMARY
PK_FoldersFolders8clustered, unique, primary key located on PRIMARY
PK_HostSettingsHostSettings8clustered, unique, primary key located on PRIMARY
PK_HtmlTextHtmlText8clustered, unique, primary key located on PRIMARY
PK_HtmlTextLogHtmlTextLog8clustered, unique, primary key located on PRIMARY
PK_HtmlTextUsersHtmlTextUsers0clustered, unique, primary key located on PRIMARY
PK_JournalJournal0clustered, unique, primary key located on PRIMARY
PK_Journal_AccessJournal_Access0clustered, unique, primary key located on PRIMARY
PK_Journal_CommentsJournal_Comments0clustered, unique, primary key located on PRIMARY
PK_Journal_DataJournal_Data0clustered, unique, primary key located on PRIMARY
IX_Journal_SecurityJournal_Security0nonclustered, unique, unique key located on PRIMARY
PK_Journal_SecurityJournal_Security0clustered, unique, primary key located on PRIMARY
PK_Journal_TypeFiltersJournal_TypeFilters0clustered, unique, primary key located on PRIMARY
PK_JournalTypesJournal_Types8clustered, unique, primary key located on PRIMARY
IX_LanguagePacksLanguagePacks0nonclustered, unique located on PRIMARY
PK_LanguagePacksLanguagePacks0clustered, unique, primary key located on PRIMARY
IX_LanguagesLanguages16nonclustered, unique located on PRIMARY
PK_LanguagesLanguages8clustered, unique, primary key located on PRIMARY
IX_LinksLinks0nonclustered located on PRIMARY
PK__Links__67FE6514Links0clustered, unique, primary key located on PRIMARY
IX_Lists_ListName_ParentIDLists40nonclustered located on PRIMARY
IX_Lists_ListName_Value_Text_ParentIDLists56nonclustered, unique, unique key located on PRIMARY
IX_Lists_ParentIDLists16nonclustered located on PRIMARY
PK_ListsLists16clustered, unique, primary key located on PRIMARY
IX_Messaging_Messages_EmailSent_EmailSchedulerInstance_StatusMessaging_Messages0nonclustered located on PRIMARY
IX_Messaging_Messages_FromUserID_StatusMessaging_Messages0nonclustered located on PRIMARY
IX_Messaging_Messages_ToUserID_Status_SkipPortalMessaging_Messages0nonclustered located on PRIMARY
PK_Messaging_MessagesMessaging_Messages0clustered, unique, primary key located on PRIMARY
PK_MetaDataMetaData8clustered, unique, primary key located on PRIMARY
IX_Mobile_PreviewProfiles_SortOrderMobile_PreviewProfiles16nonclustered located on PRIMARY
PK_Mobile_PreviewProfilesMobile_PreviewProfiles8clustered, unique, primary key located on PRIMARY
PK_Mobile_RedirectionRulesMobile_RedirectionRules0clustered, unique, primary key located on PRIMARY
IX_Mobile_Redirections_SortOrderMobile_Redirections0nonclustered located on PRIMARY
PK_Mobile_RedirectionsMobile_Redirections0clustered, unique, primary key located on PRIMARY
IX_ModuleControlsModuleControls48nonclustered, unique, unique key located on PRIMARY
IX_ModuleControls_ControlKey_ViewOrderModuleControls16nonclustered located on PRIMARY
PK_ModuleControlsModuleControls16clustered, unique, primary key located on PRIMARY
IX_ModuleDefinitionsModuleDefinitions16nonclustered, unique, unique key located on PRIMARY
IX_ModuleDefinitions_1ModuleDefinitions16nonclustered located on PRIMARY
PK_ModuleDefinitionsModuleDefinitions8clustered, unique, primary key located on PRIMARY
IX_ModulePermissionModulePermission16nonclustered, unique, unique key located on PRIMARY
IX_ModulePermission_PermissionModulePermission16nonclustered located on PRIMARY
IX_ModulePermission_RolesModulePermission16nonclustered located on PRIMARY
IX_ModulePermission_UsersModulePermission16nonclustered located on PRIMARY
PK_ModulePermissionModulePermission8clustered, unique, primary key located on PRIMARY
IX_ModulesModules16nonclustered located on PRIMARY
PK_ModulesModules8clustered, unique, primary key located on PRIMARY
PK_ModuleSettingsModuleSettings8clustered, unique, primary key located on PRIMARY
IX_PackagesPackages32nonclustered, unique located on PRIMARY
PK_PackagesPackages16clustered, unique, primary key located on PRIMARY
PK_PackageTypes_1PackageTypes8clustered, unique, primary key located on PRIMARY
IX_PermissionPermission16nonclustered, unique, unique key located on PRIMARY
PK_PermissionPermission8clustered, unique, primary key located on PRIMARY
IX_PortalAliasPortalAlias16nonclustered, unique, unique key located on PRIMARY
PK_PortalAliasPortalAlias8clustered, unique, primary key located on PRIMARY
IX_PortalDesktopModulesPortalDesktopModules16nonclustered, unique, unique key located on PRIMARY
PK_PortalDesktopModulesPortalDesktopModules8clustered, unique, primary key located on PRIMARY
PK_PortalGroupPortalGroups0clustered, unique, primary key located on PRIMARY
IX_PortalLanguagesPortalLanguages16nonclustered, unique located on PRIMARY
PK_PortalLanguagesPortalLanguages8clustered, unique, primary key located on PRIMARY
PK_PortalLocalizationPortalLocalization8clustered, unique, primary key located on PRIMARY
IX_Portals_AdministratorIdPortals16nonclustered located on PRIMARY
IX_Portals_DefaultLanguagePortals16nonclustered located on PRIMARY
PK_PortalsPortals8clustered, unique, primary key located on PRIMARY
PK_PortalSettingsPortalSettings8clustered, unique, primary key located on PRIMARY
IX_ProfileProfile16nonclustered, unique located on PRIMARY
PK_ProfileProfile8clustered, unique, primary key located on PRIMARY
IX_ProfilePropertyDefinitionProfilePropertyDefinition16nonclustered, unique located on PRIMARY
IX_ProfilePropertyDefinition_PropertyNameProfilePropertyDefinition16nonclustered located on PRIMARY
PK_ProfilePropertyDefinitionProfilePropertyDefinition8clustered, unique, primary key located on PRIMARY
IX_Relationships_UserIDRelationships16nonclustered located on PRIMARY
PK_RelationshipsRelationships8clustered, unique, primary key located on PRIMARY
PK_RelationshipTypesRelationshipTypes8clustered, unique, primary key located on PRIMARY
IX_RoleGroupNameRoleGroups0nonclustered, unique, unique key located on PRIMARY
PK_RoleGroupsRoleGroups0clustered, unique, primary key located on PRIMARY
IX_RoleNameRoles16nonclustered, unique, unique key located on PRIMARY
IX_RolesRoles16nonclustered located on PRIMARY
PK_RolesRoles8clustered, unique, primary key located on PRIMARY
PK_RoleSettingsRoleSettings0clustered, unique, primary key located on PRIMARY
PK_ScheduleSchedule8clustered, unique, primary key located on PRIMARY
IX_ScheduleHistory_NextStartScheduleHistory16nonclustered located on PRIMARY
IX_ScheduleHistory_StartDateScheduleHistory16nonclustered located on PRIMARY
PK_ScheduleHistoryScheduleHistory8clustered, unique, primary key located on PRIMARY
PK_ScheduleItemSettingsScheduleItemSettings0clustered, unique, primary key located on PRIMARY
PK_SearchCommonWordsSearchCommonWords16clustered, unique, primary key located on PRIMARY
PK_SearchIndexerSearchIndexer0clustered, unique, primary key located on PRIMARY
IX_SearchItemSearchItem16nonclustered, unique located on PRIMARY
PK_SearchItemSearchItem16clustered, unique, primary key located on PRIMARY
IX_SearchItemWordSearchItemWord56nonclustered, unique, unique key located on PRIMARY
PK_SearchItemWordsSearchItemWord16clustered, unique, primary key located on PRIMARY
PK_SearchItemWordPositionSearchItemWordPosition16clustered, unique, primary key located on PRIMARY
IX_SearchWordSearchWord32nonclustered, unique, unique key located on PRIMARY
PK_SearchWordSearchWord16clustered, unique, primary key located on PRIMARY
IX_SiteLogSiteLog0nonclustered located on PRIMARY
PK_SiteLogSiteLog0clustered, unique, primary key located on PRIMARY
PK_SkinControlsSkinControls8clustered, unique, primary key located on PRIMARY
PK_SkinPackagesSkinPackages8clustered, unique, primary key located on PRIMARY
PK_SkinsSkins8clustered, unique, primary key located on PRIMARY
IX_SystemMessagesSystemMessages0nonclustered, unique, unique key located on PRIMARY
PK_SystemMessagesSystemMessages0clustered, unique, primary key located on PRIMARY
IX_TabModulesTabModules16nonclustered, unique, unique key located on PRIMARY
IX_TabModules_UniqueIdTabModules16nonclustered, unique, unique key located on PRIMARY
PK_TabModulesTabModules16clustered, unique, primary key located on PRIMARY
PK_TabModuleSettingsTabModuleSettings8clustered, unique, primary key located on PRIMARY
IX_TabPermissionTabPermission16nonclustered, unique, unique key located on PRIMARY
IX_TabPermission_PermissionTabPermission16nonclustered located on PRIMARY
IX_TabPermission_RolesTabPermission16nonclustered located on PRIMARY
IX_TabPermission_TabsTabPermission16nonclustered located on PRIMARY
IX_TabPermission_UsersTabPermission16nonclustered located on PRIMARY
PK_TabPermissionTabPermission8clustered, unique, primary key located on PRIMARY
IX_Tabs_1Tabs16nonclustered located on PRIMARY
IX_Tabs_2Tabs16nonclustered located on PRIMARY
IX_Tabs_ContentIDTabs16nonclustered located on PRIMARY
IX_Tabs_PortalID_ParentIDTabs16nonclustered located on PRIMARY
IX_Tabs_UniqueIdTabs16nonclustered, unique, unique key located on PRIMARY
PK_TabsTabs16clustered, unique, primary key located on PRIMARY
IX_TabSettings_TabID_SettingNameTabSettings8clustered, unique located on PRIMARY
PK_ScopeTypesTaxonomy_ScopeTypes8clustered, unique, primary key located on PRIMARY
PK_Taxonomy_TermsTaxonomy_Terms8clustered, unique, primary key located on PRIMARY
PK_Taxonomy_VocabularyTaxonomy_Vocabularies8clustered, unique, primary key located on PRIMARY
PK_Taxonomy_VocabularyTypeTaxonomy_VocabularyTypes8clustered, unique, primary key located on PRIMARY
PK_UrlLogUrlLog0clustered, unique, primary key located on PRIMARY
IX_UrlsUrls0nonclustered, unique, unique key located on PRIMARY
PK_UrlsUrls0clustered, unique, primary key located on PRIMARY
IX_UrlTrackingUrlTracking0nonclustered, unique, unique key located on PRIMARY
PK_UrlTrackingUrlTracking0clustered, unique, primary key located on PRIMARY
IX_UserAuthenticationUserAuthentication0nonclustered, unique located on PRIMARY
PK_UserAuthenticationUserAuthentication0clustered, unique, primary key located on PRIMARY
IX_UserPortalsUserPortals16nonclustered located on PRIMARY
IX_UserPortals_PortalId_IsDeletedUserPortals16nonclustered located on PRIMARY
PK_UserPortalsUserPortals8clustered, unique, primary key located on PRIMARY
IX_UserProfileUserProfile16nonclustered located on PRIMARY
IX_UserProfile_UserID_PropertyDefinitionIDUserProfile16nonclustered located on PRIMARY
PK_UserProfileUserProfile8clustered, unique, primary key located on PRIMARY
PK_UserRelationshipPreferencesUserRelationshipPreferences0clustered, unique, primary key located on PRIMARY
IX_UserRelationships_RelatedUserIDUserRelationships0nonclustered located on PRIMARY
IX_UserRelationships_UserIDUserRelationships0nonclustered located on PRIMARY
IX_UserRelationships_UserID_RelatedUserID_RelationshipIDUserRelationships0nonclustered, unique located on PRIMARY
PK_UserRelationshipsUserRelationships0clustered, unique, primary key located on PRIMARY
IX_UserRolesUserRoles16nonclustered located on PRIMARY
IX_UserRoles_1UserRoles16nonclustered located on PRIMARY
PK_UserRolesUserRoles8clustered, unique, primary key located on PRIMARY
IX_UsersUsers16nonclustered, unique, unique key located on PRIMARY
IX_Users_EmailUsers16nonclustered located on PRIMARY
IX_Users_IsDeleted_DisplayNameUsers16nonclustered located on PRIMARY
PK_UsersUsers8clustered, unique, primary key located on PRIMARY
PK_UsersOnlineUsersOnline0clustered, unique, primary key located on PRIMARY
IX_VendorClassificationVendorClassification0nonclustered, unique, unique key located on PRIMARY
IX_VendorClassification_1VendorClassification0nonclustered located on PRIMARY
PK_VendorClassificationVendorClassification0clustered, unique, primary key located on PRIMARY
IX_VendorsVendors0nonclustered, unique, unique key located on PRIMARY
PK_VendorVendors0clustered, unique, primary key located on PRIMARY
IX_VersionVersion16nonclustered, unique, unique key located on PRIMARY
PK_VersionVersion8clustered, unique, primary key located on PRIMARY
PK_WebServersWebServers8clustered, unique, primary key located on PRIMARY
IX_WorkflowWorkflow16nonclustered, unique located on PRIMARY
PK_WorkflowWorkflow8clustered, unique, primary key located on PRIMARY
IX_WorkflowStatesWorkflowStates16nonclustered, unique located on PRIMARY
PK_WorkflowStatesWorkflowStates8clustered, unique, primary key located on PRIMARY







Generated by DotNetNukeRu