Microsoft Dynamics CRM 4.0 사용자 지정을 가져올 때 성능 저하 및 높은 CPU 사용률을 발생합니다

기술 자료 번역 기술 자료 번역
기술 자료: 956330 - 이 문서가 적용되는 제품 보기.
모두 확대 | 모두 축소

이 페이지에서

현상

Microsoft Dynamics CRM 4.0 성능이 사용자 지정을 가져올 때 컴퓨터에 높은 CPU 사용률이 발생합니다 MSCRM 데이터베이스 Microsoft SQL Server와 호스팅하는 실행하는 것입니다. 또한 큰 Microsoft Dynamics CRM 사용자 지정 파일 가져오는 동안 데이터에 액세스할 때 시간 제한 및 지연이 발생합니다.

해결 방법

이 문제는 최신 누적 업데이트 롤업에 대한 Microsoft Dynamics CRM 4.0 고정되어 있습니다. 추가 정보는 다음 문서 번호를 클릭하여 Microsoft 기술 자료에서 확인하십시오:
949256Microsoft Dynamics CRM 4.0 업데이트와 핫픽스를
참고 Microsoft Dynamics CRM 쿼리 실행 시간이 긴 시간을 허용하도록 REG_DWORD 값으로 다음 레지스트리 키를 설정해야 할 수도 있습니다.
HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM\OLEDBTimeout
OLEDBTimeout 키를 60 300 사이의 10진수 값으로 값을 설정해야 합니다. 과도한 SQL 차단을 방지하기 위해 우리는 300 보다 큰 값으로 설정할 사용하지 않는 것이 좋습니다.

추가 정보

선택적 단계

다음 단계를 사용하여 Microsoft SQL Server Microsoft Dynamics CRM 조정하십시오. 성능 향상을 위해 제공하는 핫픽스를 것보다 성능 향상 제공할 수 있는 선택적 단계를 사용합니다.
  1. 최적화 및 Microsoft Dynamics CRM 4.0 유지"문서에 있는 지침을 따르십시오. 이 문서를 보려면 다음 Microsoft 웹 사이트를 방문하십시오.
    http://www.microsoft.com/downloads/details.aspx?FamilyID=ba826cee-eddf-4d6e-842d-27fd654ed893&DisplayLang=en
  2. 다음 명령을 실행하여:
    USE OrganizationName_MSCRM
  3. SQL Server 관리 Studio 인덱스 및 통계를 아래에 추가하고 문을 실행하십시오.
Note You must not create these indexes if an index that has the same columns already exists.
CREATE NONCLUSTERED INDEX [CRM_LocalizedLabel_ObjectIdCustomizationLevel_KB956330] ON [MetadataSchema].[LocalizedLabel] 
(
	[ObjectId] ASC,
	[CustomizationLevel] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [CRM_LocalizedLabel_ObjectIdObjColNameCustomizationLevel_KB956330] ON [MetadataSchema].[LocalizedLabel] 
(
	[ObjectId] ASC,
	[ObjectColumnName] ASC,
	[CustomizationLevel] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [CRM_Index_Entity_KB956330] ON [MetadataSchema].[Entity] 
(
	[EntityId] ASC,
	[CustomizationLevel] ASC,
	[OwnershipTypeMask] ASC,
	[EntityRowId] ASC,
	[ObjectTypeCode] ASC
)
INCLUDE ( [PhysicalName],
[IsReplicated],
[HasDeletionStateCode]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [CRM_Stat_MetadataSchema_1_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [AttributeId], [AttributeRowId], [IsPKAttribute], [InProduction])
go

CREATE STATISTICS [CRM_Stat_MetadataSchema_2_KB956330] ON [MetadataSchema].[Relationship]([RelationshipId], [CascadeReparent], [ReferencingEntityId], [CustomizationLevel], [ReferencingAttributeId])
go

CREATE STATISTICS [CRM_Stat_MetadataSchema_3_KB956330] ON [MetadataSchema].[Relationship]([CustomizationLevel], [CascadeReparent], [RelationshipId], [RelationshipRowId], [ReferencingEntityId], [ReferencingAttributeId])
go


CREATE NONCLUSTERED INDEX [CRM_Attribute_8_727009671__K31_K22_K24_K1_KB956330] ON [MetadataSchema].[Attribute] 
(
	[YomiOf] ASC,
	[AttributeOf] ASC,
	[AggregateOf] ASC,
	[AttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_Attribute_8_727009671__K24_K31_K22_K1_KB956330] ON [MetadataSchema].[Attribute] 
(
	[AggregateOf] ASC,
	[YomiOf] ASC,
	[AttributeOf] ASC,
	[AttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_Attribute_8_727009671__K22_K31_K24_K1_KB956330] ON [MetadataSchema].[Attribute] 
(
	[AttributeOf] ASC,
	[YomiOf] ASC,
	[AggregateOf] ASC,
	[AttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_Attribute_8_727009671__K1_K31_K22_K24_KB956330] ON [MetadataSchema].[Attribute] 
(
	[AttributeId] ASC,
	[YomiOf] ASC,
	[AttributeOf] ASC,
	[AggregateOf] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_Attribute_8_727009671__K1_KB956330] ON [MetadataSchema].[Attribute] 
(
	[AttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [CRM_Stat_727009671_5_49_KB956330] ON [MetadataSchema].[Attribute]([PhysicalName], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_727009671_14_49_KB956330] ON [MetadataSchema].[Attribute]([ValidForReadAPI], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_727009671_1_13_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [LogicalName])
go

CREATE STATISTICS [CRM_Stat_727009671_24_48_KB956330] ON [MetadataSchema].[Attribute]([AggregateOf], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_49_1_KB956330] ON [MetadataSchema].[Attribute]([CustomizationLevel], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_32_49_1_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [CustomizationLevel], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_24_1_48_KB956330] ON [MetadataSchema].[Attribute]([AggregateOf], [AttributeId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_1_22_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [AttributeOf], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_31_1_48_KB956330] ON [MetadataSchema].[Attribute]([YomiOf], [AttributeId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_48_1_19_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [AttributeId], [IsCustomField])
go

CREATE STATISTICS [CRM_Stat_727009671_48_31_22_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [YomiOf], [AttributeOf])
go

CREATE STATISTICS [CRM_Stat_727009671_9_49_1_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [CustomizationLevel], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_1_31_49_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [YomiOf], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_727009671_1_32_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [AttributeRowId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_35_9_1_KB956330] ON [MetadataSchema].[Attribute]([Locked], [EntityId], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_20_48_49_KB956330] ON [MetadataSchema].[Attribute]([IsLogical], [InProduction], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_727009671_1_32_31_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [AttributeRowId], [YomiOf])
go

CREATE STATISTICS [CRM_Stat_727009671_49_13_1_KB956330] ON [MetadataSchema].[Attribute]([CustomizationLevel], [LogicalName], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_1_2_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [AttributeTypeId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_32_22_1_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [AttributeOf], [AttributeId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_32_24_1_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [AggregateOf], [AttributeId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_20_1_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [IsLogical], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_9_48_49_19_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [InProduction], [CustomizationLevel], [IsCustomField])
go

CREATE STATISTICS [CRM_Stat_727009671_22_9_1_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeOf], [EntityId], [AttributeId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_13_49_9_48_KB956330] ON [MetadataSchema].[Attribute]([LogicalName], [CustomizationLevel], [EntityId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_32_1_31_49_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [AttributeId], [YomiOf], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_727009671_5_48_49_9_KB956330] ON [MetadataSchema].[Attribute]([PhysicalName], [InProduction], [CustomizationLevel], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_1_31_22_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [YomiOf], [AttributeOf], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_2_49_48_32_KB956330] ON [MetadataSchema].[Attribute]([AttributeTypeId], [CustomizationLevel], [InProduction], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_51_1_48_49_KB956330] ON [MetadataSchema].[Attribute]([IsRowGuidAttribute], [AttributeId], [InProduction], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_727009671_1_9_3_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [EntityId], [Name], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_1_48_49_31_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [InProduction], [CustomizationLevel], [YomiOf])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_18_9_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [IsPKAttribute], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_51_9_1_48_KB956330] ON [MetadataSchema].[Attribute]([IsRowGuidAttribute], [EntityId], [AttributeId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_32_9_49_1_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [EntityId], [CustomizationLevel], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_2_9_1_22_KB956330] ON [MetadataSchema].[Attribute]([AttributeTypeId], [EntityId], [AttributeId], [AttributeOf])
go

CREATE STATISTICS [CRM_Stat_727009671_32_9_1_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [EntityId], [AttributeId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_1_32_19_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [AttributeRowId], [IsCustomField], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_1_19_49_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [IsCustomField], [CustomizationLevel], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_18_1_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [IsPKAttribute], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_22_1_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [AttributeOf], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_9_11_49_48_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [ColumnNumber], [CustomizationLevel], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_19_1_9_48_KB956330] ON [MetadataSchema].[Attribute]([IsCustomField], [AttributeId], [EntityId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_9_49_48_1_51_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [CustomizationLevel], [InProduction], [AttributeId], [IsRowGuidAttribute])
go

CREATE STATISTICS [CRM_Stat_727009671_32_9_48_49_5_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [EntityId], [InProduction], [CustomizationLevel], [PhysicalName])
go

CREATE STATISTICS [CRM_Stat_727009671_11_48_49_20_9_KB956330] ON [MetadataSchema].[Attribute]([ColumnNumber], [InProduction], [CustomizationLevel], [IsLogical], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_9_49_19_20_48_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [CustomizationLevel], [IsCustomField], [IsLogical], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_32_31_22_1_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [YomiOf], [AttributeOf], [AttributeId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_49_48_32_1_31_KB956330] ON [MetadataSchema].[Attribute]([CustomizationLevel], [InProduction], [AttributeRowId], [AttributeId], [YomiOf])
go

CREATE STATISTICS [CRM_Stat_727009671_32_9_3_48_49_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [EntityId], [Name], [InProduction], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_727009671_13_49_48_1_9_KB956330] ON [MetadataSchema].[Attribute]([LogicalName], [CustomizationLevel], [InProduction], [AttributeId], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_14_2_1_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [ValidForReadAPI], [AttributeTypeId], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_14_2_9_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [ValidForReadAPI], [AttributeTypeId], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_20_49_19_48_32_KB956330] ON [MetadataSchema].[Attribute]([IsLogical], [CustomizationLevel], [IsCustomField], [InProduction], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_1_48_49_32_14_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [InProduction], [CustomizationLevel], [AttributeRowId], [ValidForReadAPI])
go

CREATE STATISTICS [CRM_Stat_727009671_20_9_48_49_1_KB956330] ON [MetadataSchema].[Attribute]([IsLogical], [EntityId], [InProduction], [CustomizationLevel], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_3_14_49_48_9_KB956330] ON [MetadataSchema].[Attribute]([Name], [ValidForReadAPI], [CustomizationLevel], [InProduction], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_24_1_32_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [AggregateOf], [AttributeId], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_31_22_48_49_1_KB956330] ON [MetadataSchema].[Attribute]([YomiOf], [AttributeOf], [InProduction], [CustomizationLevel], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_19_48_49_32_1_KB956330] ON [MetadataSchema].[Attribute]([IsCustomField], [InProduction], [CustomizationLevel], [AttributeRowId], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_49_19_20_48_1_KB956330] ON [MetadataSchema].[Attribute]([CustomizationLevel], [IsCustomField], [IsLogical], [InProduction], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_49_20_48_32_1_KB956330] ON [MetadataSchema].[Attribute]([CustomizationLevel], [IsLogical], [InProduction], [AttributeRowId], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_1_48_49_9_11_20_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [InProduction], [CustomizationLevel], [EntityId], [ColumnNumber], [IsLogical])
go

CREATE STATISTICS [CRM_Stat_727009671_31_9_1_48_49_22_KB956330] ON [MetadataSchema].[Attribute]([YomiOf], [EntityId], [AttributeId], [InProduction], [CustomizationLevel], [AttributeOf])
go

CREATE STATISTICS [CRM_Stat_727009671_19_9_48_49_5_1_KB956330] ON [MetadataSchema].[Attribute]([IsCustomField], [EntityId], [InProduction], [CustomizationLevel], [PhysicalName], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_9_3_48_49_1_32_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [Name], [InProduction], [CustomizationLevel], [AttributeId], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_22_48_49_31_32_1_KB956330] ON [MetadataSchema].[Attribute]([AttributeOf], [InProduction], [CustomizationLevel], [YomiOf], [AttributeRowId], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_18_14_2_9_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [IsPKAttribute], [ValidForReadAPI], [AttributeTypeId], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_1_49_48_32_9_14_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [CustomizationLevel], [InProduction], [AttributeRowId], [EntityId], [ValidForReadAPI])
go

CREATE STATISTICS [CRM_Stat_727009671_1_48_49_32_19_20_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [InProduction], [CustomizationLevel], [AttributeRowId], [IsCustomField], [IsLogical])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_1_2_9_11_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [AttributeId], [AttributeTypeId], [EntityId], [ColumnNumber])
go

CREATE STATISTICS [CRM_Stat_727009671_9_22_24_31_48_49_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [AttributeOf], [AggregateOf], [YomiOf], [InProduction], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_727009671_2_9_48_49_1_18_KB956330] ON [MetadataSchema].[Attribute]([AttributeTypeId], [EntityId], [InProduction], [CustomizationLevel], [AttributeId], [IsPKAttribute])
go

CREATE STATISTICS [CRM_Stat_727009671_1_48_49_9_5_32_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [InProduction], [CustomizationLevel], [EntityId], [PhysicalName], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_1_9_48_49_5_20_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [EntityId], [InProduction], [CustomizationLevel], [PhysicalName], [IsLogical])
go

CREATE STATISTICS [CRM_Stat_727009671_22_24_31_48_49_1_KB956330] ON [MetadataSchema].[Attribute]([AttributeOf], [AggregateOf], [YomiOf], [InProduction], [CustomizationLevel], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_1_48_49_32_22_14_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [InProduction], [CustomizationLevel], [AttributeRowId], [AttributeOf], [ValidForReadAPI])
go

CREATE STATISTICS [CRM_Stat_727009671_1_48_49_32_9_19_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [InProduction], [CustomizationLevel], [AttributeRowId], [EntityId], [IsCustomField])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_18_14_2_1_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [IsPKAttribute], [ValidForReadAPI], [AttributeTypeId], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_1_2_32_5_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [AttributeId], [AttributeTypeId], [AttributeRowId], [PhysicalName])
go

CREATE STATISTICS [CRM_Stat_727009671_11_20_19_49_48_9_KB956330] ON [MetadataSchema].[Attribute]([ColumnNumber], [IsLogical], [IsCustomField], [CustomizationLevel], [InProduction], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_3_14_2_49_48_9_KB956330] ON [MetadataSchema].[Attribute]([Name], [ValidForReadAPI], [AttributeTypeId], [CustomizationLevel], [InProduction], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_1_2_49_48_32_9_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [AttributeTypeId], [CustomizationLevel], [InProduction], [AttributeRowId], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_11_48_49_9_20_32_KB956330] ON [MetadataSchema].[Attribute]([ColumnNumber], [InProduction], [CustomizationLevel], [EntityId], [IsLogical], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_32_13_49_1_48_9_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [LogicalName], [CustomizationLevel], [AttributeId], [InProduction], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_1_48_49_32_22_24_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [InProduction], [CustomizationLevel], [AttributeRowId], [AttributeOf], [AggregateOf])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_18_14_50_9_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [IsPKAttribute], [ValidForReadAPI], [HasMultipleLabels], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_32_9_48_49_1_20_11_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [EntityId], [InProduction], [CustomizationLevel], [AttributeId], [IsLogical], [ColumnNumber])
go

CREATE STATISTICS [CRM_Stat_727009671_9_1_48_49_32_22_14_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [AttributeId], [InProduction], [CustomizationLevel], [AttributeRowId], [AttributeOf], [ValidForReadAPI])
go

CREATE STATISTICS [CRM_Stat_727009671_1_48_49_32_20_19_11_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [InProduction], [CustomizationLevel], [AttributeRowId], [IsLogical], [IsCustomField], [ColumnNumber])
go

CREATE STATISTICS [CRM_Stat_727009671_14_2_49_48_32_1_9_KB956330] ON [MetadataSchema].[Attribute]([ValidForReadAPI], [AttributeTypeId], [CustomizationLevel], [InProduction], [AttributeRowId], [AttributeId], [EntityId])
go

CREATE STATISTICS [CRM_Stat_727009671_14_2_49_48_32_1_22_KB956330] ON [MetadataSchema].[Attribute]([ValidForReadAPI], [AttributeTypeId], [CustomizationLevel], [InProduction], [AttributeRowId], [AttributeId], [AttributeOf])
go

CREATE STATISTICS [CRM_Stat_727009671_1_48_49_32_18_14_2_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [InProduction], [CustomizationLevel], [AttributeRowId], [IsPKAttribute], [ValidForReadAPI], [AttributeTypeId])
go

CREATE STATISTICS [CRM_Stat_727009671_32_9_48_49_1_18_14_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [EntityId], [InProduction], [CustomizationLevel], [AttributeId], [IsPKAttribute], [ValidForReadAPI])
go

CREATE STATISTICS [CRM_Stat_727009671_22_9_48_49_1_14_2_KB956330] ON [MetadataSchema].[Attribute]([AttributeOf], [EntityId], [InProduction], [CustomizationLevel], [AttributeId], [ValidForReadAPI], [AttributeTypeId])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_18_14_50_1_32_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [IsPKAttribute], [ValidForReadAPI], [HasMultipleLabels], [AttributeId], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_3_49_48_14_2_32_22_KB956330] ON [MetadataSchema].[Attribute]([Name], [CustomizationLevel], [InProduction], [ValidForReadAPI], [AttributeTypeId], [AttributeRowId], [AttributeOf])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_9_1_2_32_5_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [EntityId], [AttributeId], [AttributeTypeId], [AttributeRowId], [PhysicalName])
go

CREATE STATISTICS [CRM_Stat_727009671_49_48_9_1_19_20_32_KB956330] ON [MetadataSchema].[Attribute]([CustomizationLevel], [InProduction], [EntityId], [AttributeId], [IsCustomField], [IsLogical], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_49_48_32_1_9_22_24_KB956330] ON [MetadataSchema].[Attribute]([CustomizationLevel], [InProduction], [AttributeRowId], [AttributeId], [EntityId], [AttributeOf], [AggregateOf])
go

CREATE STATISTICS [CRM_Stat_727009671_49_48_32_1_9_5_20_KB956330] ON [MetadataSchema].[Attribute]([CustomizationLevel], [InProduction], [AttributeRowId], [AttributeId], [EntityId], [PhysicalName], [IsLogical])
go

CREATE STATISTICS [CRM_Stat_727009671_24_31_48_49_22_32_1_KB956330] ON [MetadataSchema].[Attribute]([AggregateOf], [YomiOf], [InProduction], [CustomizationLevel], [AttributeOf], [AttributeRowId], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_727009671_49_48_1_9_18_14_50_32_KB956330] ON [MetadataSchema].[Attribute]([CustomizationLevel], [InProduction], [AttributeId], [EntityId], [IsPKAttribute], [ValidForReadAPI], [HasMultipleLabels], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_9_1_48_49_3_14_2_32_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [AttributeId], [InProduction], [CustomizationLevel], [Name], [ValidForReadAPI], [AttributeTypeId], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_9_49_48_1_18_14_2_32_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [CustomizationLevel], [InProduction], [AttributeId], [IsPKAttribute], [ValidForReadAPI], [AttributeTypeId], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_1_48_49_9_22_24_31_32_KB956330] ON [MetadataSchema].[Attribute]([AttributeId], [InProduction], [CustomizationLevel], [EntityId], [AttributeOf], [AggregateOf], [YomiOf], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_5_20_19_9_1_32_11_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [PhysicalName], [IsLogical], [IsCustomField], [EntityId], [AttributeId], [AttributeRowId], [ColumnNumber])
go

CREATE STATISTICS [CRM_Stat_727009671_48_9_49_1_14_2_32_22_3_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [EntityId], [CustomizationLevel], [AttributeId], [ValidForReadAPI], [AttributeTypeId], [AttributeRowId], [AttributeOf], [Name])
go

CREATE NONCLUSTERED INDEX [CRM_ViewAttribute_8_1303011723__K2_K7_K6_K1_KB956330] ON [MetadataSchema].[ViewAttribute] 
(
	[AttributeId] ASC,
	[CustomizationLevel] ASC,
	[ViewAttributeRowId] ASC,
	[ViewAttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_ViewAttribute_8_1303011723__K2_K7_1_6_KB956330] ON [MetadataSchema].[ViewAttribute] 
(
	[AttributeId] ASC,
	[CustomizationLevel] ASC
)
INCLUDE ( [ViewAttributeId],
[ViewAttributeRowId]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_ViewAttribute_8_1303011723__K2_K4_KB956330] ON [MetadataSchema].[ViewAttribute] 
(
	[AttributeId] ASC,
	[RemoteAttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_ViewAttribute_8_1303011723__K4_K2_KB956330] ON [MetadataSchema].[ViewAttribute] 
(
	[RemoteAttributeId] ASC,
	[AttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [CRM_Stat_1303011723_1_6_KB956330] ON [MetadataSchema].[ViewAttribute]([ViewAttributeId], [ViewAttributeRowId])
go

CREATE STATISTICS [CRM_Stat_1303011723_7_3_KB956330] ON [MetadataSchema].[ViewAttribute]([CustomizationLevel], [RelationshipId])
go

CREATE STATISTICS [CRM_Stat_1303011723_6_4_7_KB956330] ON [MetadataSchema].[ViewAttribute]([ViewAttributeRowId], [RemoteAttributeId], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_1303011723_1_4_7_KB956330] ON [MetadataSchema].[ViewAttribute]([ViewAttributeId], [RemoteAttributeId], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_1303011723_7_2_1_KB956330] ON [MetadataSchema].[ViewAttribute]([CustomizationLevel], [AttributeId], [ViewAttributeId])
go

CREATE STATISTICS [CRM_Stat_1303011723_4_2_7_6_KB956330] ON [MetadataSchema].[ViewAttribute]([RemoteAttributeId], [AttributeId], [CustomizationLevel], [ViewAttributeRowId])
go

CREATE STATISTICS [CRM_Stat_1303011723_7_4_2_1_KB956330] ON [MetadataSchema].[ViewAttribute]([CustomizationLevel], [RemoteAttributeId], [AttributeId], [ViewAttributeId])
go

CREATE STATISTICS [CRM_Stat_1303011723_7_6_1_4_KB956330] ON [MetadataSchema].[ViewAttribute]([CustomizationLevel], [ViewAttributeRowId], [ViewAttributeId], [RemoteAttributeId])
go

CREATE STATISTICS [CRM_Stat_1303011723_2_1_6_3_KB956330] ON [MetadataSchema].[ViewAttribute]([AttributeId], [ViewAttributeId], [ViewAttributeRowId], [RelationshipId])
go

CREATE STATISTICS [CRM_Stat_1303011723_7_6_1_3_KB956330] ON [MetadataSchema].[ViewAttribute]([CustomizationLevel], [ViewAttributeRowId], [ViewAttributeId], [RelationshipId])
go

CREATE STATISTICS [CRM_Stat_1303011723_7_2_4_3_KB956330] ON [MetadataSchema].[ViewAttribute]([CustomizationLevel], [AttributeId], [RemoteAttributeId], [RelationshipId])
go

CREATE STATISTICS [CRM_Stat_1303011723_1_2_7_3_KB956330] ON [MetadataSchema].[ViewAttribute]([ViewAttributeId], [AttributeId], [CustomizationLevel], [RelationshipId])
go

CREATE STATISTICS [CRM_Stat_1303011723_3_7_6_1_4_KB956330] ON [MetadataSchema].[ViewAttribute]([RelationshipId], [CustomizationLevel], [ViewAttributeRowId], [ViewAttributeId], [RemoteAttributeId])
go

CREATE STATISTICS [CRM_Stat_1303011723_4_2_1_6_3_KB956330] ON [MetadataSchema].[ViewAttribute]([RemoteAttributeId], [AttributeId], [ViewAttributeId], [ViewAttributeRowId], [RelationshipId])
go

CREATE STATISTICS [CRM_Stat_1303011723_1_2_7_4_3_KB956330] ON [MetadataSchema].[ViewAttribute]([ViewAttributeId], [AttributeId], [CustomizationLevel], [RemoteAttributeId], [RelationshipId])
go

CREATE STATISTICS [CRM_Stat_1303011723_3_2_7_6_1_KB956330] ON [MetadataSchema].[ViewAttribute]([RelationshipId], [AttributeId], [CustomizationLevel], [ViewAttributeRowId], [ViewAttributeId])
go

CREATE STATISTICS [CRM_Stat_1303011723_6_2_7_4_3_KB956330] ON [MetadataSchema].[ViewAttribute]([ViewAttributeRowId], [AttributeId], [CustomizationLevel], [RemoteAttributeId], [RelationshipId])
go

CREATE STATISTICS [CRM_Stat_1303011723_2_7_6_1_4_3_KB956330] ON [MetadataSchema].[ViewAttribute]([AttributeId], [CustomizationLevel], [ViewAttributeRowId], [ViewAttributeId], [RemoteAttributeId], [RelationshipId])
go

CREATE NONCLUSTERED INDEX [CRM_Relationship_8_1015010697__K4_K6_KB956330] ON [MetadataSchema].[Relationship] 
(
	[ReferencingAttributeId] ASC,
	[ReferencedAttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_Relationship_8_1015010697__K6_K4_KB956330] ON [MetadataSchema].[Relationship] 
(
	[ReferencedAttributeId] ASC,
	[ReferencingAttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [CRM_Stat_1015010697_19_1_KB956330] ON [MetadataSchema].[Relationship]([RelationshipRowId], [RelationshipId])
go

CREATE STATISTICS [CRM_Stat_1015010697_2_20_KB956330] ON [MetadataSchema].[Relationship]([Name], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_1015010697_1_5_19_KB956330] ON [MetadataSchema].[Relationship]([RelationshipId], [ReferencedEntityId], [RelationshipRowId])
go

CREATE STATISTICS [CRM_Stat_1015010697_1_19_20_2_KB956330] ON [MetadataSchema].[Relationship]([RelationshipId], [RelationshipRowId], [CustomizationLevel], [Name])
go

CREATE STATISTICS [CRM_Stat_1015010697_6_4_20_1_KB956330] ON [MetadataSchema].[Relationship]([ReferencedAttributeId], [ReferencingAttributeId], [CustomizationLevel], [RelationshipId])
go

CREATE STATISTICS [CRM_Stat_1015010697_20_1_5_6_4_KB956330] ON [MetadataSchema].[Relationship]([CustomizationLevel], [RelationshipId], [ReferencedEntityId], [ReferencedAttributeId], [ReferencingAttributeId])
go

CREATE STATISTICS [CRM_Stat_1015010697_20_1_19_6_4_KB956330] ON [MetadataSchema].[Relationship]([CustomizationLevel], [RelationshipId], [RelationshipRowId], [ReferencedAttributeId], [ReferencingAttributeId])
go

CREATE STATISTICS [CRM_Stat_1015010697_1_3_7_20_5_KB956330] ON [MetadataSchema].[Relationship]([RelationshipId], [ReferencingEntityId], [RelationshipType], [CustomizationLevel], [ReferencedEntityId])
go

CREATE STATISTICS [CRM_Stat_1015010697_1_20_19_5_6_KB956330] ON [MetadataSchema].[Relationship]([RelationshipId], [CustomizationLevel], [RelationshipRowId], [ReferencedEntityId], [ReferencedAttributeId])
go

CREATE STATISTICS [CRM_Stat_1015010697_5_1_19_3_7_KB956330] ON [MetadataSchema].[Relationship]([ReferencedEntityId], [RelationshipId], [RelationshipRowId], [ReferencingEntityId], [RelationshipType])
go

CREATE STATISTICS [CRM_Stat_1015010697_1_5_6_4_19_KB956330] ON [MetadataSchema].[Relationship]([RelationshipId], [ReferencedEntityId], [ReferencedAttributeId], [ReferencingAttributeId], [RelationshipRowId])
go

CREATE STATISTICS [CRM_Stat_1015010697_5_4_1_19_3_7_KB956330] ON [MetadataSchema].[Relationship]([ReferencedEntityId], [ReferencingAttributeId], [RelationshipId], [RelationshipRowId], [ReferencingEntityId], [RelationshipType])
go

CREATE STATISTICS [CRM_Stat_1015010697_3_7_20_5_4_1_KB956330] ON [MetadataSchema].[Relationship]([ReferencingEntityId], [RelationshipType], [CustomizationLevel], [ReferencedEntityId], [ReferencingAttributeId], [RelationshipId])
go

CREATE STATISTICS [CRM_Stat_1015010697_20_1_19_4_3_7_KB956330] ON [MetadataSchema].[Relationship]([CustomizationLevel], [RelationshipId], [RelationshipRowId], [ReferencingAttributeId], [ReferencingEntityId], [RelationshipType])
go

CREATE STATISTICS [CRM_Stat_1015010697_19_3_7_20_5_4_KB956330] ON [MetadataSchema].[Relationship]([RelationshipRowId], [ReferencingEntityId], [RelationshipType], [CustomizationLevel], [ReferencedEntityId], [ReferencingAttributeId])
go

CREATE STATISTICS [CRM_Stat_1015010697_5_20_1_19_3_7_4_KB956330] ON [MetadataSchema].[Relationship]([ReferencedEntityId], [CustomizationLevel], [RelationshipId], [RelationshipRowId], [ReferencingEntityId], [RelationshipType], [ReferencingAttributeId])
go

CREATE STATISTICS [CRM_Stat_1015010697_1_4_20_19_5_6_2_KB956330] ON [MetadataSchema].[Relationship]([RelationshipId], [ReferencingAttributeId], [CustomizationLevel], [RelationshipRowId], [ReferencedEntityId], [ReferencedAttributeId], [Name])
go

CREATE NONCLUSTERED INDEX [CRM_IndexAttributes_8_983010583__K2_KB956330] ON [MetadataSchema].[IndexAttributes] 
(
	[AttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [CRM_Stat_983010583_5_4_3_KB956330] ON [MetadataSchema].[IndexAttributes]([IsIncludeAttribute], [IndexOrder], [IndexId])
go

CREATE STATISTICS [CRM_Stat_983010583_2_3_5_4_KB956330] ON [MetadataSchema].[IndexAttributes]([AttributeId], [IndexId], [IsIncludeAttribute], [IndexOrder])
go

CREATE NONCLUSTERED INDEX [CRM_RelationshipExtraCondition_8_1207011381__K3_KB956330] ON [MetadataSchema].[RelationshipExtraCondition] 
(
	[AttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_Entity_8_359008360__K9_K46_K36_K1_K45_KB956330] ON [MetadataSchema].[Entity] 
(
	[BaseTableName] ASC,
	[CustomizationLevel] ASC,
	[ReportViewName] ASC,
	[EntityId] ASC,
	[EntityRowId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [CRM_Stat_359008360_1_4_KB956330] ON [MetadataSchema].[Entity]([EntityId], [ObjectTypeCode])
go

CREATE STATISTICS [CRM_Stat_359008360_1_9_KB956330] ON [MetadataSchema].[Entity]([EntityId], [BaseTableName])
go

CREATE STATISTICS [CRM_Stat_359008360_2_46_KB956330] ON [MetadataSchema].[Entity]([Name], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_359008360_1_5_KB956330] ON [MetadataSchema].[Entity]([EntityId], [PhysicalName])
go

CREATE STATISTICS [CRM_Stat_359008360_46_45_1_KB956330] ON [MetadataSchema].[Entity]([CustomizationLevel], [EntityRowId], [EntityId])
go

CREATE STATISTICS [CRM_Stat_359008360_1_46_5_KB956330] ON [MetadataSchema].[Entity]([EntityId], [CustomizationLevel], [PhysicalName])
go

CREATE STATISTICS [CRM_Stat_359008360_45_4_46_KB956330] ON [MetadataSchema].[Entity]([EntityRowId], [ObjectTypeCode], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_359008360_1_36_46_KB956330] ON [MetadataSchema].[Entity]([EntityId], [ReportViewName], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_359008360_46_16_1_KB956330] ON [MetadataSchema].[Entity]([CustomizationLevel], [IsLogicalEntity], [EntityId])
go

CREATE STATISTICS [CRM_Stat_359008360_45_46_36_KB956330] ON [MetadataSchema].[Entity]([EntityRowId], [CustomizationLevel], [ReportViewName])
go

CREATE STATISTICS [CRM_Stat_359008360_46_9_1_KB956330] ON [MetadataSchema].[Entity]([CustomizationLevel], [BaseTableName], [EntityId])
go

CREATE STATISTICS [CRM_Stat_359008360_4_46_1_KB956330] ON [MetadataSchema].[Entity]([ObjectTypeCode], [CustomizationLevel], [EntityId])
go

CREATE STATISTICS [CRM_Stat_359008360_45_2_46_KB956330] ON [MetadataSchema].[Entity]([EntityRowId], [Name], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_359008360_1_46_2_45_KB956330] ON [MetadataSchema].[Entity]([EntityId], [CustomizationLevel], [Name], [EntityRowId])
go

CREATE STATISTICS [CRM_Stat_359008360_46_1_45_36_KB956330] ON [MetadataSchema].[Entity]([CustomizationLevel], [EntityId], [EntityRowId], [ReportViewName])
go

CREATE STATISTICS [CRM_Stat_359008360_5_46_16_1_KB956330] ON [MetadataSchema].[Entity]([PhysicalName], [CustomizationLevel], [IsLogicalEntity], [EntityId])
go

CREATE STATISTICS [CRM_Stat_359008360_1_45_4_46_KB956330] ON [MetadataSchema].[Entity]([EntityId], [EntityRowId], [ObjectTypeCode], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_359008360_1_46_45_9_KB956330] ON [MetadataSchema].[Entity]([EntityId], [CustomizationLevel], [EntityRowId], [BaseTableName])
go

CREATE STATISTICS [CRM_Stat_359008360_45_46_9_36_KB956330] ON [MetadataSchema].[Entity]([EntityRowId], [CustomizationLevel], [BaseTableName], [ReportViewName])
go

CREATE STATISTICS [CRM_Stat_359008360_1_46_45_16_KB956330] ON [MetadataSchema].[Entity]([EntityId], [CustomizationLevel], [EntityRowId], [IsLogicalEntity])
go

CREATE STATISTICS [CRM_Stat_359008360_36_46_9_1_45_KB956330] ON [MetadataSchema].[Entity]([ReportViewName], [CustomizationLevel], [BaseTableName], [EntityId], [EntityRowId])
go

CREATE STATISTICS [CRM_Stat_359008360_45_5_46_1_16_KB956330] ON [MetadataSchema].[Entity]([EntityRowId], [PhysicalName], [CustomizationLevel], [EntityId], [IsLogicalEntity])
go

CREATE STATISTICS [CRM_Stat_1395536055_1_3_KB956330] ON [MetadataSchema].[EntityRelationshipRole]([EntityRelationshipRoleId], [EntityId])
go

CREATE STATISTICS [CRM_Stat_1395536055_13_3_KB956330] ON [MetadataSchema].[EntityRelationshipRole]([EntityRelationshipRoleRowId], [EntityId])
go

CREATE STATISTICS [CRM_Stat_1395536055_13_2_KB956330] ON [MetadataSchema].[EntityRelationshipRole]([EntityRelationshipRoleRowId], [EntityRelationshipId])
go

CREATE STATISTICS [CRM_Stat_1395536055_15_2_13_KB956330] ON [MetadataSchema].[EntityRelationshipRole]([CustomizationLevel], [EntityRelationshipId], [EntityRelationshipRoleRowId])
go

CREATE STATISTICS [CRM_Stat_1395536055_15_13_1_KB956330] ON [MetadataSchema].[EntityRelationshipRole]([CustomizationLevel], [EntityRelationshipRoleRowId], [EntityRelationshipRoleId])
go

CREATE STATISTICS [CRM_Stat_1395536055_2_15_1_KB956330] ON [MetadataSchema].[EntityRelationshipRole]([EntityRelationshipId], [CustomizationLevel], [EntityRelationshipRoleId])
go

CREATE STATISTICS [CRM_Stat_1395536055_3_15_1_KB956330] ON [MetadataSchema].[EntityRelationshipRole]([EntityId], [CustomizationLevel], [EntityRelationshipRoleId])
go

CREATE STATISTICS [CRM_Stat_1395536055_15_3_13_KB956330] ON [MetadataSchema].[EntityRelationshipRole]([CustomizationLevel], [EntityId], [EntityRelationshipRoleRowId])
go

CREATE STATISTICS [CRM_Stat_1395536055_2_15_3_13_KB956330] ON [MetadataSchema].[EntityRelationshipRole]([EntityRelationshipId], [CustomizationLevel], [EntityId], [EntityRelationshipRoleRowId])
go

CREATE STATISTICS [CRM_Stat_1395536055_2_1_13_15_KB956330] ON [MetadataSchema].[EntityRelationshipRole]([EntityRelationshipId], [EntityRelationshipRoleId], [EntityRelationshipRoleRowId], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_1395536055_1_13_3_15_2_KB956330] ON [MetadataSchema].[EntityRelationshipRole]([EntityRelationshipRoleId], [EntityRelationshipRoleRowId], [EntityId], [CustomizationLevel], [EntityRelationshipId])
go

CREATE STATISTICS [CRM_Stat_691533547_9_1_KB956330] ON [MetadataSchema].[LocalizedLabel]([CustomizationLevel], [LocalizedLabelId])
go

CREATE STATISTICS [CRM_Stat_691533547_4_1_8_KB956330] ON [MetadataSchema].[LocalizedLabel]([ObjectId], [LocalizedLabelId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_691533547_2_9_1_KB956330] ON [MetadataSchema].[LocalizedLabel]([LocalizedLabelRowId], [CustomizationLevel], [LocalizedLabelId])
go

CREATE STATISTICS [CRM_Stat_691533547_8_2_9_KB956330] ON [MetadataSchema].[LocalizedLabel]([InProduction], [LocalizedLabelRowId], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_691533547_5_3_9_KB956330] ON [MetadataSchema].[LocalizedLabel]([ObjectColumnName], [LanguageId], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_691533547_5_9_8_KB956330] ON [MetadataSchema].[LocalizedLabel]([ObjectColumnName], [CustomizationLevel], [InProduction])
go

CREATE STATISTICS [CRM_Stat_691533547_9_8_5_1_KB956330] ON [MetadataSchema].[LocalizedLabel]([CustomizationLevel], [InProduction], [ObjectColumnName], [LocalizedLabelId])
go

CREATE STATISTICS [CRM_Stat_691533547_4_9_3_8_KB956330] ON [MetadataSchema].[LocalizedLabel]([ObjectId], [CustomizationLevel], [LanguageId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_691533547_8_9_4_1_KB956330] ON [MetadataSchema].[LocalizedLabel]([InProduction], [CustomizationLevel], [ObjectId], [LocalizedLabelId])
go

CREATE STATISTICS [CRM_Stat_691533547_4_5_9_8_KB956330] ON [MetadataSchema].[LocalizedLabel]([ObjectId], [ObjectColumnName], [CustomizationLevel], [InProduction])
go

CREATE STATISTICS [CRM_Stat_691533547_3_5_9_8_KB956330] ON [MetadataSchema].[LocalizedLabel]([LanguageId], [ObjectColumnName], [CustomizationLevel], [InProduction])
go

CREATE STATISTICS [CRM_Stat_691533547_8_4_5_1_KB956330] ON [MetadataSchema].[LocalizedLabel]([InProduction], [ObjectId], [ObjectColumnName], [LocalizedLabelId])
go

CREATE STATISTICS [CRM_Stat_691533547_9_3_8_1_KB956330] ON [MetadataSchema].[LocalizedLabel]([CustomizationLevel], [LanguageId], [InProduction], [LocalizedLabelId])
go

CREATE STATISTICS [CRM_Stat_691533547_2_4_9_1_KB956330] ON [MetadataSchema].[LocalizedLabel]([LocalizedLabelRowId], [ObjectId], [CustomizationLevel], [LocalizedLabelId])
go

CREATE STATISTICS [CRM_Stat_691533547_2_4_1_8_KB956330] ON [MetadataSchema].[LocalizedLabel]([LocalizedLabelRowId], [ObjectId], [LocalizedLabelId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_691533547_2_4_5_9_1_KB956330] ON [MetadataSchema].[LocalizedLabel]([LocalizedLabelRowId], [ObjectId], [ObjectColumnName], [CustomizationLevel], [LocalizedLabelId])
go

CREATE STATISTICS [CRM_Stat_691533547_2_3_5_9_1_KB956330] ON [MetadataSchema].[LocalizedLabel]([LocalizedLabelRowId], [LanguageId], [ObjectColumnName], [CustomizationLevel], [LocalizedLabelId])
go

CREATE STATISTICS [CRM_Stat_691533547_1_8_9_2_3_KB956330] ON [MetadataSchema].[LocalizedLabel]([LocalizedLabelId], [InProduction], [CustomizationLevel], [LocalizedLabelRowId], [LanguageId])
go

CREATE STATISTICS [CRM_Stat_691533547_1_8_9_2_4_KB956330] ON [MetadataSchema].[LocalizedLabel]([LocalizedLabelId], [InProduction], [CustomizationLevel], [LocalizedLabelRowId], [ObjectId])
go

CREATE STATISTICS [CRM_Stat_691533547_1_4_5_9_8_2_KB956330] ON [MetadataSchema].[LocalizedLabel]([LocalizedLabelId], [ObjectId], [ObjectColumnName], [CustomizationLevel], [InProduction], [LocalizedLabelRowId])
go

CREATE STATISTICS [CRM_Stat_691533547_1_3_5_9_8_2_KB956330] ON [MetadataSchema].[LocalizedLabel]([LocalizedLabelId], [LanguageId], [ObjectColumnName], [CustomizationLevel], [InProduction], [LocalizedLabelRowId])
go

CREATE STATISTICS [CRM_Stat_691533547_4_9_1_8_3_2_KB956330] ON [MetadataSchema].[LocalizedLabel]([ObjectId], [CustomizationLevel], [LocalizedLabelId], [InProduction], [LanguageId], [LocalizedLabelRowId])
go

CREATE STATISTICS [CRM_Stat_931534402_4_7_KB956330] ON [MetadataSchema].[AttributeLookupValue]([InProduction], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_931534402_7_1_3_KB956330] ON [MetadataSchema].[AttributeLookupValue]([CustomizationLevel], [AttributeLookupValueId], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_931534402_3_4_7_KB956330] ON [MetadataSchema].[AttributeLookupValue]([AttributeId], [InProduction], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_931534402_1_2_4_KB956330] ON [MetadataSchema].[AttributeLookupValue]([AttributeLookupValueId], [AttributeLookupValueRowId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_931534402_1_4_7_2_KB956330] ON [MetadataSchema].[AttributeLookupValue]([AttributeLookupValueId], [InProduction], [CustomizationLevel], [AttributeLookupValueRowId])
go

CREATE STATISTICS [CRM_Stat_931534402_1_3_4_7_2_KB956330] ON [MetadataSchema].[AttributeLookupValue]([AttributeLookupValueId], [AttributeId], [InProduction], [CustomizationLevel], [AttributeLookupValueRowId])
go

CREATE STATISTICS [CRM_Stat_935010412_7_4_KB956330] ON [MetadataSchema].[EntityIndex]([RecreateIndex], [IsClustered])
go

CREATE STATISTICS [CRM_Stat_851534117_10_1_KB956330] ON [MetadataSchema].[AttributePicklistValue]([CustomizationLevel], [AttributePicklistValueId])
go

CREATE STATISTICS [CRM_Stat_851534117_10_4_KB956330] ON [MetadataSchema].[AttributePicklistValue]([CustomizationLevel], [InProduction])
go

CREATE STATISTICS [CRM_Stat_851534117_1_3_10_KB956330] ON [MetadataSchema].[AttributePicklistValue]([AttributePicklistValueId], [AttributeId], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_851534117_3_4_10_KB956330] ON [MetadataSchema].[AttributePicklistValue]([AttributeId], [InProduction], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_851534117_1_4_10_2_KB956330] ON [MetadataSchema].[AttributePicklistValue]([AttributePicklistValueId], [InProduction], [CustomizationLevel], [AttributePicklistValueRowId])
go

CREATE STATISTICS [CRM_Stat_851534117_8_10_4_3_KB956330] ON [MetadataSchema].[AttributePicklistValue]([DisplayOrder], [CustomizationLevel], [InProduction], [AttributeId])
go

CREATE STATISTICS [CRM_Stat_851534117_1_4_10_8_KB956330] ON [MetadataSchema].[AttributePicklistValue]([AttributePicklistValueId], [InProduction], [CustomizationLevel], [DisplayOrder])
go

CREATE STATISTICS [CRM_Stat_851534117_1_3_4_10_2_KB956330] ON [MetadataSchema].[AttributePicklistValue]([AttributePicklistValueId], [AttributeId], [InProduction], [CustomizationLevel], [AttributePicklistValueRowId])
go

CREATE STATISTICS [CRM_Stat_851534117_3_10_4_1_8_2_KB956330] ON [MetadataSchema].[AttributePicklistValue]([AttributeId], [CustomizationLevel], [InProduction], [AttributePicklistValueId], [DisplayOrder], [AttributePicklistValueRowId])
go

CREATE NONCLUSTERED INDEX [CRM_AttributeIds_8_291532122__K1_KB956330] ON [dbo].[AttributeIds] 
(
	[AttributeId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [CRM_Stat_1650104919_32_31_KB956330] ON [dbo].[SavedQueryBase]([SavedQueryIdUnique], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_1650104919_1_33_KB956330] ON [dbo].[SavedQueryBase]([SavedQueryId], [InProduction])
go

CREATE STATISTICS [CRM_Stat_1650104919_31_1_33_30_KB956330] ON [dbo].[SavedQueryBase]([CustomizationLevel], [SavedQueryId], [InProduction], [IsPrivate])
go

CREATE STATISTICS [CRM_Stat_1650104919_32_1_31_33_30_KB956330] ON [dbo].[SavedQueryBase]([SavedQueryIdUnique], [SavedQueryId], [CustomizationLevel], [InProduction], [IsPrivate])
go

CREATE STATISTICS [CRM_Stat_626101271_15_17_KB956330] ON [dbo].[OrganizationUIBase]([FormIdUnique], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_626101271_1_15_6_KB956330] ON [dbo].[OrganizationUIBase]([FormId], [FormIdUnique], [InProduction])
go

CREATE STATISTICS [CRM_Stat_626101271_1_15_5_6_KB956330] ON [dbo].[OrganizationUIBase]([FormId], [FormIdUnique], [ObjectTypeCode], [InProduction])
go

CREATE STATISTICS [CRM_Stat_626101271_1_15_17_6_KB956330] ON [dbo].[OrganizationUIBase]([FormId], [FormIdUnique], [CustomizationLevel], [InProduction])
go

CREATE STATISTICS [CRM_Stat_626101271_5_6_17_1_15_KB956330] ON [dbo].[OrganizationUIBase]([ObjectTypeCode], [InProduction], [CustomizationLevel], [FormId], [FormIdUnique])
go


CREATE NONCLUSTERED INDEX [CRM_Index_Attribute_8_727009671__K1_K48_K49_K32_5_KB956330] ON [MetadataSchema].[Attribute] 
(
	[AttributeId] ASC,
	[InProduction] ASC,
	[CustomizationLevel] ASC,
	[AttributeRowId] ASC
)
INCLUDE ( [PhysicalName]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_Index_Attribute_8_727009671__K18_K9_K48_K49_K1_K32_5_KB956330] ON [MetadataSchema].[Attribute] 
(
	[IsPKAttribute] ASC,
	[EntityId] ASC,
	[InProduction] ASC,
	[CustomizationLevel] ASC,
	[AttributeId] ASC,
	[AttributeRowId] ASC
)
INCLUDE ( [PhysicalName]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_Index_Attribute_8_727009671__K18_K48_K49_K1_K32_5_KB956330] ON [MetadataSchema].[Attribute] 
(
	[IsPKAttribute] ASC,
	[InProduction] ASC,
	[CustomizationLevel] ASC,
	[AttributeId] ASC,
	[AttributeRowId] ASC
)
INCLUDE ( [PhysicalName]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [CRM_Stat_727009671_48_49_18_32_KB956330] ON [MetadataSchema].[Attribute]([InProduction], [CustomizationLevel], [IsPKAttribute], [AttributeRowId])
go

CREATE STATISTICS [CRM_Stat_727009671_32_9_18_48_KB956330] ON [MetadataSchema].[Attribute]([AttributeRowId], [EntityId], [IsPKAttribute], [InProduction])
go

CREATE STATISTICS [CRM_Stat_727009671_9_48_49_18_32_KB956330] ON [MetadataSchema].[Attribute]([EntityId], [InProduction], [CustomizationLevel], [IsPKAttribute], [AttributeRowId])
go

CREATE NONCLUSTERED INDEX [CRM_Index_Relationship_8_1015010697__K1_K3_K20_K14_K5_K4_K19_KB956330] ON [MetadataSchema].[Relationship] 
(
	[RelationshipId] ASC,
	[ReferencingEntityId] ASC,
	[CustomizationLevel] ASC,
	[CascadeReparent] ASC,
	[ReferencedEntityId] ASC,
	[ReferencingAttributeId] ASC,
	[RelationshipRowId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_Index_Relationship_8_1015010697__K14_K3_K20_K5_K4_K1_K19_KB956330] ON [MetadataSchema].[Relationship] 
(
	[CascadeReparent] ASC,
	[ReferencingEntityId] ASC,
	[CustomizationLevel] ASC,
	[ReferencedEntityId] ASC,
	[ReferencingAttributeId] ASC,
	[RelationshipId] ASC,
	[RelationshipRowId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [CRM_Stat_1015010697_20_1_19_3_KB956330] ON [MetadataSchema].[Relationship]([CustomizationLevel], [RelationshipId], [RelationshipRowId], [ReferencingEntityId])
go

CREATE STATISTICS [CRM_Stat_1015010697_3_5_4_20_KB956330] ON [MetadataSchema].[Relationship]([ReferencingEntityId], [ReferencedEntityId], [ReferencingAttributeId], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_1015010697_20_14_1_19_3_KB956330] ON [MetadataSchema].[Relationship]([CustomizationLevel], [CascadeReparent], [RelationshipId], [RelationshipRowId], [ReferencingEntityId])
go

CREATE STATISTICS [CRM_Stat_1015010697_19_3_20_14_5_4_KB956330] ON [MetadataSchema].[Relationship]([RelationshipRowId], [ReferencingEntityId], [CustomizationLevel], [CascadeReparent], [ReferencedEntityId], [ReferencingAttributeId])
go

CREATE STATISTICS [CRM_Stat_1015010697_3_5_4_1_19_20_KB956330] ON [MetadataSchema].[Relationship]([ReferencingEntityId], [ReferencedEntityId], [ReferencingAttributeId], [RelationshipId], [RelationshipRowId], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_1015010697_3_5_20_14_1_19_KB956330] ON [MetadataSchema].[Relationship]([ReferencingEntityId], [ReferencedEntityId], [CustomizationLevel], [CascadeReparent], [RelationshipId], [RelationshipRowId])
go

CREATE NONCLUSTERED INDEX [CRM_Index_Entity_8_359008360__K22_K46_K1_K45_K4_5_28_40_KB956330] ON [MetadataSchema].[Entity] 
(
	[OwnershipTypeMask] ASC,
	[CustomizationLevel] ASC,
	[EntityId] ASC,
	[EntityRowId] ASC,
	[ObjectTypeCode] ASC
)
INCLUDE ( [PhysicalName],
[IsReplicated],
[HasDeletionStateCode]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_Index_Entity_8_359008360__K1_K46_K45_KB956330] ON [MetadataSchema].[Entity] 
(
	[EntityId] ASC,
	[CustomizationLevel] ASC,
	[EntityRowId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE NONCLUSTERED INDEX [CRM_Index_Entity_8_359008360__K46_K1_K45_KB956330] ON [MetadataSchema].[Entity] 
(
	[CustomizationLevel] ASC,
	[EntityId] ASC,
	[EntityRowId] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [CRM_Stat_359008360_46_22_45_KB956330] ON [MetadataSchema].[Entity]([CustomizationLevel], [OwnershipTypeMask], [EntityRowId])
go

CREATE STATISTICS [CRM_Stat_359008360_4_46_22_KB956330] ON [MetadataSchema].[Entity]([ObjectTypeCode], [CustomizationLevel], [OwnershipTypeMask])
go

CREATE STATISTICS [CRM_Stat_359008360_22_1_46_KB956330] ON [MetadataSchema].[Entity]([OwnershipTypeMask], [EntityId], [CustomizationLevel])
go

CREATE STATISTICS [CRM_Stat_359008360_45_1_22_46_4_KB956330] ON [MetadataSchema].[Entity]([EntityRowId], [EntityId], [OwnershipTypeMask], [CustomizationLevel], [ObjectTypeCode])
go
소프트웨어 업데이트 용어에 대한 자세한 내용은 Microsoft 기술 자료의 다음 문서를 참조하십시오.
824684Microsoft 소프트웨어 업데이트를 설명하는 데 사용되는 표준 용어에 대한 설명
Microsoft 비즈니스 솔루션 CRM 소프트웨어 업데이트 및 핫픽스 패키지 용어에 대한 자세한 내용은 Microsoft 기술 자료의 다음 문서를 참조하십시오.
887283Microsoft 비즈니스 솔루션 CRM 소프트웨어 핫픽스 및 업데이트를 명명 표준을 패키지합니다

속성

기술 자료: 956330 - 마지막 검토: 2009년 3월 12일 목요일 - 수정: 1.0
본 문서의 정보는 다음의 제품에 적용됩니다.
  • Microsoft Dynamics CRM 4.0
키워드:?
kbmt kbsurveynew kbmbsmigrate kbqfe KB956330 KbMtko
기계 번역된 문서
중요: 본 문서는 전문 번역가가 번역한 것이 아니라 Microsoft 기계 번역 소프트웨어로 번역한 것입니다. Microsoft는 번역가가 번역한 문서 및 기계 번역된 문서를 모두 제공하므로 Microsoft 기술 자료에 있는 모든 문서를 한글로 접할 수 있습니다. 그러나 기계 번역 문서가 항상 완벽한 것은 아닙니다. 따라서 기계 번역 문서에는 마치 외국인이 한국어로 말할 때 실수를 하는 것처럼 어휘, 구문 또는 문법에 오류가 있을 수 있습니다. Microsoft는 내용상의 오역 또는 Microsoft 고객이 이러한 오역을 사용함으로써 발생하는 부 정확성, 오류 또는 손해에 대해 책임을 지지 않습니다. Microsoft는 이러한 문제를 해결하기 위해 기계 번역 소프트웨어를 자주 업데이트하고 있습니다.

피드백 보내기

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com