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)))