Hi, I am seen below long runnnig query on Remedy Server which causes performance issues. Does anyone knows what is his query?
Thanks Vishal 895060 SQL 0000218104 Prv:390680 390680 Remedy Application Service Tue Jan 08 2013 09:20:30.1500 SELECT TOP 2001 T1916.C1,C1000000161,C301626500,C1000000000,C7,C1000000164,C1000000217,C1000000218,C179,C230000009,C3 FROM T1916 WHERE (((T1916.C230000009 = N'MAINCHANGE') AND ((T1916.C1000000716 = N'ranjselv') OR (T1916.C4 = N'ranjselv') OR (T1916.C4 = N'ranjselv')) AND ((T1916.C7 = 1) OR (T1916.C7 = 2) OR (T1916.C7 = 3) OR (T1916.C7 = 4) OR (T1916.C7 = 5) OR (T1916.C7 = 6) OR (T1916.C7 = 7) OR (T1916.C7 = 8) OR (T1916.C7 = 9))) OR ((T1916.C230000009 = N'MAINHELPDESK') AND (T1916.C4 = N'ranjselv') AND ((T1916.C7 = 0) OR (T1916.C7 = 1) OR (T1916.C7 = 2) OR (T1916.C7 = 3))) OR ((T1916.C230000009 = N'TMSTASK') AND (T1916.C4 = N'ranjselv') AND ((T1916.C7 = 1000) OR (T1916.C7 = 2000) OR (T1916.C7 = 3000) OR (T1916.C7 = 4000) OR (T1916.C7 = 5000))) OR ((T1916.C230000009 = N'MAINKNOWLEDGEDATABASE') AND (T1916.C4 = N'ranjselv') AND (T1916.C7 = 4)) OR ((T1916.C230000009 = N'MAINKNOWNERROR') AND (T1916.C4 = N'ranjselv') AND ((T1916.C7 = 0) OR (T1916.C7 = 1) OR (T1916.C7 = 2))) OR ((T1916.C230000009 = N'MAINPROBLEM') AND (T1916.C4 = N'ranjselv') AND ((T1916.C7 = 0) OR (T1916.C7 = 1) OR (T1916.C7 = 2) OR (T1916.C7 = 3) OR (T1916.C7 = 4) OR (T1916.C7 = 5)))) ORDER BY C1000000161 ASC, 1 ASC _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
