#1957 [HHQ-2238] enhance / investigate slow query in HQ

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-2238
Slow query is ->

  SELECT M.ID FROM EAM_MEASUREMENT M, EAM_MEASUREMENT_TEMPL T, EAM_MONITORABLE_TYPE MT WHERE M.TEMPLATE_ID = T.ID AND T.MONITORABLE_TYPE_ID = MT.ID AND M.MEASUREMENT_CLASS='S' AND ((MT.APPDEF_TYPE = N AND M.INSTANCE_ID NOT IN (SELECT INSTANCE_ID FROM EAM_RESOURCE WHERE RESOURCE_TYPE_ID = N)) OR (MT.APPDEF_TYPE = N AND M.INSTANCE_ID NOT IN (SELECT INSTANCE_ID FROM EAM_RESOURCE WHERE RESOURCE_TYPE_ID = N)) OR (MT.APPDEF_TYPE = N AND M.INSTANCE_ID NOT IN (SELECT INSTANCE_ID FROM EAM_RESOURCE WHERE RESOURCE_TYPE_ID = N)))