Database reference - DotNetNuke 5.6

DotNetNuke 5.6 -  indexes

Index overview

nametablesize (kb)description
PK_AffiliatesAffiliates0clustered, unique, primary key located on PRIMARY
PK_AnonymousUsersAnonymousUsers8clustered, unique, primary key located on PRIMARY
aspnet_Applications_Indexaspnet_Applications8clustered located on PRIMARY
PK__aspnet_A__C93A4C983B60C8C7aspnet_Applications16nonclustered, unique, primary key located on PRIMARY
UQ__aspnet_A__17477DE43E3D3572aspnet_Applications16nonclustered, unique, unique key located on PRIMARY
UQ__aspnet_A__309103314119A21Daspnet_Applications16nonclustered, unique, unique key located on PRIMARY
aspnet_Membership_indexaspnet_Membership8clustered located on PRIMARY
PK__aspnet_M__1788CC4D59E54FE7aspnet_Membership16nonclustered, unique, primary key located on PRIMARY
PK__aspnet_P__1788CC4C70C8B53Faspnet_Profile0clustered, unique, primary key located on PRIMARY
aspnet_Roles_index1aspnet_Roles0clustered, unique located on PRIMARY
PK__aspnet_R__8AFACE1B7C3A67EBaspnet_Roles0nonclustered, unique, primary key located on PRIMARY
PK__aspnet_S__5A1E6BC14D7F7902aspnet_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__1788CC4D45DE573Aaspnet_Users16nonclustered, unique, primary key located on PRIMARY
aspnet_UsersInRoles_indexaspnet_UsersInRoles0nonclustered located on PRIMARY
PK__aspnet_U__AF2760AD01F34141aspnet_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_ContentItemsContentItems8clustered, unique, primary key located on PRIMARY
PK_Content_MetaDataContentItems_MetaData0clustered, unique, primary key located on PRIMARY
IX_ContentItems_TagsContentItems_Tags0nonclustered, unique located on PRIMARY
IX_ContentItems_Tags_TermIDContentItems_Tags0nonclustered located on PRIMARY
PK_ContentItems_TagsContentItems_Tags0clustered, unique, primary key located on PRIMARY
PK_ContentTypesContentTypes8clustered, 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_EventLogConfigEventLogConfig8clustered, 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_FileFiles8clustered, 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
IX_LanguagePacksLanguagePacks16nonclustered, unique located on PRIMARY
PK_LanguagePacksLanguagePacks8clustered, 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__67FE6514Links0nonclustered, unique, primary key located on PRIMARY
IX_Lists_ListName_ParentIDLists32nonclustered located on PRIMARY
IX_Lists_ListName_Value_Text_ParentIDLists40nonclustered, unique, unique key located on PRIMARY
IX_Lists_ParentIDLists16nonclustered located on PRIMARY
PK_ListsLists16clustered, unique, primary key located on PRIMARY
PK_Messaging_MessagesMessaging_Messages8clustered, unique, primary key located on PRIMARY
PK_MetaDataMetaData8clustered, unique, primary key located on PRIMARY
IX_ModuleControlsModuleControls40nonclustered, 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_ModulesModules16nonclustered, unique, primary key located on PRIMARY
PK_ModuleSettingsModuleSettings8clustered, unique, primary key located on PRIMARY
IX_PackagesPackages40nonclustered, 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
IX_PortalLanguagesPortalLanguages16nonclustered, unique located on PRIMARY
PK_PortalLanguagesPortalLanguages8clustered, unique, primary key located on PRIMARY
IX_Portals_AdministratorIdPortals16nonclustered located on PRIMARY
IX_Portals_DefaultLanguagePortals16nonclustered located on PRIMARY
PK_PortalsPortals16nonclustered, 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_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_RolesRoles16nonclustered, 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_ScheduleHistoryScheduleHistory16clustered, 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_SearchItemSearchItem8clustered, unique, primary key located on PRIMARY
IX_SearchItemWordSearchItemWord72nonclustered, unique, unique key located on PRIMARY
PK_SearchItemWordsSearchItemWord16clustered, unique, primary key located on PRIMARY
PK_SearchItemWordPositionSearchItemWordPosition16clustered, unique, primary key located on PRIMARY
IX_SearchWordSearchWord16nonclustered, 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_SettingNameTabSettings16clustered, unique located on PRIMARY
PK_ScopeTypesTaxonomy_ScopeTypes8clustered, unique, primary key located on PRIMARY
PK_Taxonomy_TermsTaxonomy_Terms0clustered, 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
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
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_UsersOnlineUsersOnline8clustered, 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