A colleague just created 2 queries that according to the Collection Evaluation Viewer tool have a run time of 6,324 and 6199 seconds (90 minutes). Nothing else comes close to this. they are relatively simple queries. the only difference is the CompanyName. One is specific and the other has a wildcard at the end. Does anyone know a better way to do this collection query?
select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.CompanyName like "Interactive Intelligence%" Dave
