create index IX_Relationship1 on AssetAttributeValue (AssetId);
create index IX_Relationship6 on AssetBoxAsset (AssetId);
create index IX_Relationship8 on CM_ItemInCategory (ItemId);
create index IX_Relationship39 on AttributeValue (AssetId);
create index IX_Relationship49 on AssetUse (AssetId);
create index IX_Relationship66 on AssetApproval (AssetId);
create index IX_Relationship77 on AssetView (AssetId);
create index IX_Relationship95 on RelatedAsset (ParentId);
create index IX_Relationship96 on RelatedAsset (ChildId);
create index IX_Relationship135 on AssetBoxPriceBand (AssetId);
create index IX_Relationship150 on FeaturedAssetInBrand (AssetId);
create index IX_Relationship214 on AssetInMarketingEmail (AssetId);
create index IX_Relationship219 on Asset (CurrentVersionId);
create index IX_Relationship241 on AssetChangeLog (AssetId);
create index IX_Relationship263 on RepurposedAsset (AssetId);
create index IX_Relationship273 on AssetAgreement (AssetId);
create index IX_Relationship278 on AssetRating (AssetId);
create index IX_Relationship282 on AssetWorkflowAudit (AssetId);
create index IX_Relationship5 on AssetBoxAsset (AssetBoxId);
create index IX_Relationship134 on AssetBoxPriceBand (AssetBoxId);
create index IX_Relationship158 on AssetBoxShare (AssetBoxId);
create index IX_Relationship22 on Asset (AddedByUserId);
create index IX_Relationship47 on UserInGroup (UserId);
create index IX_Relationship51 on AssetUse (UserId);
create index IX_Relationship52 on AssetBox (UserId);
create index IX_Relationship63 on AssetView (UserId);
create index IX_Relationship67 on AssetApproval (UserId);
create index IX_Relationship69 on Asset (LastModifiedByUserId);
create index IX_Relationship78 on ABOrder (UserId);
create index IX_Relationship120 on Subscription (UserId);
create index IX_Relationship159 on AssetBoxShare (UserId);
create index IX_Relationship164 on AssetBoxAsset (AddedByUserId);
create index IX_Relationship172 on UserInMarketingGroup (UserId);
create index IX_Relationship187 on AssetBankUser (LastModifiedById);
create index IX_Relationship195 on SavedSearch (UserId);
create index IX_Relationship243 on SessionLog (UserId);
create index IX_Relationship259 on Filter (UserId);
create index IX_Relationship264 on RepurposedAsset (CreatedByUserId);
create index IX_Relationship279 on AssetRating (UserId);
create index IX_Relationship284 on AssetWorkflowAudit (UserId);
create index IX_Relationship285 on AssetBankUser (InvitedByUserId);
create index IX_Relationship9 on CM_ItemInCategory (CategoryId);
create index IX_Relationship10 on CM_Category (ParentId);
create index IX_Relationship35 on CategoryVisibleToGroup (CategoryId);
create index IX_Relationship177 on TranslatedCategory (CategoryId);
create index IX_Relationship290 on FilterForCategory (CategoryId);
create index IX_Relationship2 on AssetAttributeValue (AttributeValueId);
create index IX_Relationship169 on FilterAttributeValue (AttributeValueId);
create index IX_Relationship176 on TranslatedAttributeValue (AttributeValueId);
create index IX_Relationship4 on AttributeValue (AttributeId);
create index IX_Relationship40 on GroupAttributeExclusion (AttributeId);
create index IX_Relationship45 on AttributeVisibleToGroup (AttributeId);
create index IX_Relationship46 on AssetAttributeValue (AttributeId);
create index IX_Relationship86 on ChangeAttributeValueDateRule (ChangeAttributeId);
create index IX_Relationship89 on ChangeAttributeValueDateRule (AttributeId);
create index IX_Relationship90 on SendEmailDateRule (AttributeId);
create index IX_Relationship126 on SortAttribute (AttributeId);
create index IX_Relationship163 on EmbeddedDataMapping (AttributeId);
create index IX_Relationship173 on TranslatedAttribute (AttributeId);
create index IX_Relationship253 on AssetEntityAttribute (AttributeId);
create index IX_Relationship7 on CM_Category (CategoryTypeId);
create index IX_Relationship34 on CategoryVisibleToGroup (UserGroupId);
create index IX_Relationship41 on GroupAttributeExclusion (UserGroupId);
create index IX_Relationship44 on AttributeVisibleToGroup (UserGroupId);
create index IX_Relationship48 on UserInGroup (UserGroupId);
create index IX_Relationship73 on OrgUnit (AdminGroupId);
create index IX_Relationship75 on OrgUnitGroup (UserGroupId);
create index IX_Relationship81 on OrgUnit (StandardGroupId);
create index IX_Relationship88 on GroupEmailRule (UserGroupId);
create index IX_Relationship100 on GroupUsageExclusion (UserGroupId);
create index IX_Relationship108 on GroupInSubscriptionModel (UserGroupId);
create index IX_Relationship154 on GroupIsRole (UserGroupId);
create index IX_Relationship167 on ScheduledReportGroup (GroupId);
create index IX_Relationship288 on GroupFilterExclusion (UserGroupId);
create index IX_Relationship19 on Attribute (AttributeTypeId);
create index IX_Relationship27 on Asset (AssetTypeId);
create index IX_Relationship58 on FileFormat (AssetTypeId);
create index IX_Relationship153 on UsageType (AssetTypeId);
create index IX_Relationship223 on PriceBand (AssetTypeId);
create index IX_Relationship254 on AllowableEntityAssetType (AssetTypeId);
create index IX_Relationship50 on AssetUse (UsageTypeId);
create index IX_Relationship70 on AssetApproval (UsageTypeId);
create index IX_Relationship82 on UsageTypeFormat (UsageTypeId);
create index IX_Relationship97 on UsageType (ParentId);
create index IX_Relationship99 on GroupUsageExclusion (UsageTypeId);
create index IX_Relationship129 on PriceBandUsage (UsageTypeId);
create index IX_Relationship181 on TranslatedUsageType (UsageTypeId);
create index IX_Relationship57 on AssetUse (AssetDownloadTypeId);
create index IX_Relationship60 on Asset (FileFormatId);
create index IX_Relationship83 on UsageTypeFormat (FormatId);
create index IX_Relationship265 on RepurposedAsset (FileFormatId);
create index IX_Relationship68 on AssetApproval (ApprovalStatusId);
create index IX_Relationship74 on OrgUnitGroup (OrgUnitId);
create index IX_Relationship101 on AssetBankUser (RequestedOrgUnitId);
create index IX_Relationship275 on OrgUnitForAgreement (OrgUnitId);
create index IX_Relationship79 on AssetPurchaseLog (ABOrderId);
create index IX_Relationship140 on AssetPurchasePriceBand (ABOrderId,AssetId);
create index IX_Relationship183 on TranslatedUsageTypeFormat (UsageTypeFormatId);
create index IX_Relationship87 on GroupEmailRule (RuleId);
create index IX_Relationship102 on ListItem (ListId);
create index IX_Relationship103 on AssetBankUser (DivisionId);
create index IX_Relationship107 on GroupInSubscriptionModel (SubscriptionModelId);
create index IX_Relationship119 on Subscription (SubscriptionModelId);
create index IX_Relationship121 on SubscriptionModelUpgrade (FromId);
create index IX_Relationship122 on SubscriptionModelUpgrade (ToId);
create index IX_Relationship207 on TranslatedSubscriptionModel (SubscriptionModelId);
create index IX_Relationship110 on AssetBankUser (AddressId);
create index IX_Relationship139 on ABOrder (ShippingAddressId);
create index IX_Relationship109 on Address (CountryId);
create index IX_Relationship118 on CountryInTaxRegion (CountryId);
create index IX_Relationship113 on TaxValue (TaxTypeId);
create index IX_Relationship218 on TranslatedTaxType (TaxTypeId);
create index IX_Relationship115 on TaxValue (TaxRegionId);
create index IX_Relationship117 on CountryInTaxRegion (TaxRegionId);
create index IX_Relationship131 on ShippingCost (TaxRegionId);
create index IX_Relationship206 on TranslatedTaxRegion (TaxRegionId);
create index IX_Relationship125 on SortAttribute (SortAreaId);
create index IX_Relationship130 on PriceBandUsage (PriceBandId);
create index IX_Relationship132 on ShippingCost (PriceBandId);
create index IX_Relationship136 on AssetBoxPriceBand (PriceBandId);
create index IX_Relationship205 on TranslatedPriceBand (PriceBandId);
create index IX_Relationship128 on PriceBand (PriceBandTypeId);
create index IX_Relationship204 on TranslatedPriceBandType (PriceBandTypeId);
create index IX_Relationship133 on ShippingCost (QuantityRangeId);
create index IX_Relationship145 on CommercialOptionPurchase (CommercialOptionId);
create index IX_Relationship202 on TranslatedCommercialOption (CommercialOptionId);
create index IX_Relationship138 on ABOrder (OrderStatusId);
create index IX_Relationship208 on TranslatedOrderStatus (OrderStatusId);
create index IX_Relationship141 on OrderStatus (OrderWorkflowId);
create index IX_Relationship147 on FeaturedAssetInBrand (BrandId);
create index IX_Relationship149 on UserGroup (BrandId);
create index IX_Relationship152 on ListItem (ListItemTextTypeId);
create index IX_Relationship155 on GroupIsRole (RoleId);
create index IX_Relationship156 on EmailTemplate (LanguageId);
create index IX_Relationship174 on TranslatedAttribute (LanguageId);
create index IX_Relationship175 on TranslatedAttributeValue (LanguageId);
create index IX_Relationship178 on TranslatedCategory (LanguageId);
create index IX_Relationship179 on ListItem (LanguageId);
create index IX_Relationship180 on AssetBankUser (LanguageId);
create index IX_Relationship182 on TranslatedUsageType (LanguageId);
create index IX_Relationship184 on TranslatedUsageTypeFormat (LanguageId);
create index IX_Relationship186 on TranslatedFilter (LanguageId);
create index IX_Relationship197 on TranslatedMarketingGroup (LanguageId);
create index IX_Relationship201 on TranslatedCommercialOption (LanguageId);
create index IX_Relationship203 on TranslatedPriceBandType (LanguageId);
create index IX_Relationship209 on TranslatedPriceBand (LanguageId);
create index IX_Relationship210 on TranslatedTaxRegion (LanguageId);
create index IX_Relationship211 on TranslatedSubscriptionModel (LanguageId);
create index IX_Relationship212 on TranslatedOrderStatus (LanguageId);
create index IX_Relationship216 on TranslatedMarketingEmail (LanguageId);
create index IX_Relationship217 on TranslatedTaxType (LanguageId);
create index IX_Relationship231 on TranslatedCustomField (LanguageId);
create index IX_Relationship251 on TranslatedAssetEntity (LanguageId);
create index IX_Relationship252 on TranslatedEntityRelationship (LanguageId);
create index IX_Relationship271 on TranslatedAgreement (LanguageId);
create index IX_Relationship277 on TranslatedNewsItem (LanguageId);
create index IX_Relationship1642 on EmbeddedDataMapping (EmbeddedDataValueId);
create index IX_Relationship15822 on EmbeddedDataValue (EmbeddedDataTypeId);
create index IX_Relationship1652 on EmbeddedDataMapping (MappingDirectionId);
create index IX_Relationship165 on ScheduledReportGroup (ReportId);
create index IX_Relationship164222 on FilterAttributeValue (FilterId);
create index IX_Relationship185 on TranslatedFilter (FilterId);
create index IX_Relationship261 on FilterInGroup (FilterId);
create index IX_Relationship287 on GroupFilterExclusion (FilterId);
create index IX_Relationship289 on FilterForCategory (FilterId);
create index IX_Relationship1662 on UserInMarketingGroup (MarketingGroupId);
create index IX_Relationship196 on TranslatedMarketingGroup (MarketingGroupId);
create index IX_Relationship190222 on CustomField (UsageTypeId);
create index IX_Relationship191222 on CustomFieldValue (CustomFieldId);
create index IX_Relationship201222 on CustomFieldValueMapping (CustomFieldId);
create index IX_Relationship232 on TranslatedCustomField (CustomFieldId);
create index IX_Relationship187222 on CustomField (TypeId);
create index IX_Relationship200222 on CustomFieldValueMapping (ListValue);
create index IX_Relationship198 on EmailTemplate (TypeId);
create index IX_Relationship2162 on AssetInMarketingEmail (MarketingEmailId);
create index IX_Relationship215 on TranslatedMarketingEmail (MarketingEmailId);
create index IX_Relationship229 on AssetChangeLog (LogTypeId);
create index IX_Relationship237 on AssetUse (SessionLogId);
create index IX_Relationship238 on AssetView (SessionLogId);
create index IX_Relationship239 on AssetChangeLog (SessionLogId);
create index IX_Relationship23322 on AllowableEntityRelationship (AssetEntityId);
create index IX_Relationship23522 on AssetEntityAttribute (AssetEntityId);
create index IX_Relationship23822 on AllowableEntityAssetType (AssetEntityId);
create index IX_Relationship2412 on TranslatedAssetEntity (AssetEntityId);
create index IX_Relationship2502 on AllowableEntityRelationship (RelatesToAssetEntityId);
create index IX_Relationship256 on Asset (AssetEntityId);
create Index IX_Relationship2472 on TranslatedEntityRelationship(AssetEntityId,RelationshipTypeId);
create index IX_Relationship23422 on AllowableEntityRelationship (RelationshipTypeId);
create index IX_Relationship255 on RelatedAsset (RelationshipTypeId);
create index IX_Relationship258 on Filter (FilterTypeId);
create index IX_Relationship260 on FilterGroup (FilterTypeId);
create index IX_Relationship262 on FilterInGroup (GroupId);
create index IX_Relationship266 on ChangeAttributeValueDateRule (ActionOnAssetId);
create index IX_Relationship267 on AttributeValue (ActionOnAssetId);
create index IX_Relationship269 on TranslatedAgreement (AgreementId);
create index IX_Relationship272 on AssetAgreement (AgreementId);
create index IX_Relationship274 on OrgUnitForAgreement (AgreementId);
create index IX_Relationship2702 on TranslatedNewsItem (NewsItemId);
create index IX_Relationship286 on UsageTypeFormat (ConvertToColorSpaceId);