/*
	bug 230959  9.2 SP1 - E10111: command UpdatePlugins errors in TraceExpertSystem.
	The timeout occurs because on deletion from ManagedElementAttributeType 
	there is not appropriate index on [ManagedElementAttributeData] 
	to quickly show that there is no data (for ME Concrete tables) to trigger FOREIGN KEY
	 CONSTRAINT [ManagedElementAttributeData_ManagedElementAttributeTypeGuid_ManagedElementAttributeType_ManagedElementAttributeTypeGuid_FK] 
 
 Creating the index below will spead up the deletion and eliminate timeouts
*/
create nonclustered index ManagedElementAttributeData_ManagedElementAttributeTypeGuid_IX
		on [ManagedElementAttributeData](ManagedElementAttributeTypeGuid)
go