Following Defect & Knowledge article can be referred - SW00443560 KA380785
Following fields will need to be indexed - 'C230000009', 'C1000000079' & 'C7' Indexing to be done at the db level for better performance and after indexing customer should get 'execution plan' aka 'explain plan' of the query by running it on db directly and see the time difference between pre-indexing and post-indexing. That will tell you whether or not solution implemented is helping. Thanks Anay.. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Vishal Navale Sent: Wednesday, January 09, 2013 1:13 AM To: [email protected] Subject: Re: Long Running Query ** Thanks Rick for the answer. Modify the query and indexing - do you have some suggestions for how to do this. Thanks Vishal On Tue, Jan 8, 2013 at 2:00 PM, Rick Cook <[email protected]<mailto:[email protected]>> wrote: modifying the query, _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
