The following query runs an average of 20,000 times per hour. We are unable to determine if this is Quick Search or some other report written that is being refreshed forever.
Any ideas? Thanks Joe SELECT main.* FROM ( SELECT DISTINCT main.id FROM Users main JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Principals_1.id ) WHERE (Principals_1.Disabled = '0') AND (CachedGroupMembers_2.GroupId = '919190') AND (CachedGroupMembers_2.Disabled = '0') AND (lower(Principals_1.PrincipalType) = 'user') ) distinctquery, Users main WHERE (main.id = distinctquery.id) ORDER BY main.Name ASC Joe Kirby , Assistant Vice President, Business Systems Division of Information Technology (DoIT) Support Response - http://www.umbc.edu/doit Administration 627 Office - 410-455-3020 Email - ki...@umbc.edu
-- RT Training - Dallas May 20-21 http://bestpractical.com/training