Check out the QBE match on the field being searched. It probably says Anywhere. Change it to leading or equal. This would be done in the Admin tool for the form being searched.
On 11/21/11, john.athe...@schneider-electric.com <john.athe...@schneider-electric.com> wrote: > When I search on a field the holds the Kinetic number (KSR) the action > takes along time to complete compared to the time it takes to search on > the ICN number > > > Below is what my DBA sent me. > > When searching by KSR it runs this sql which ignores the index: > > SELECT * FROM ( SELECT > T1908.C1,C1000000161,C1000000018,C1000000019,C1000000000,C303497300,C1000000164,C7,C1000000217,C1000000218,C1000005261,C1000003009 > FROM T1908 WHERE (T1908.C800021100 LIKE '%KSR000000304374%') ORDER BY > C1000000161 DESC, 1 ASC ) WHERE ROWNUM <= 9001 > > When searching by Incident Num it runs this sql which returns in seconds: > > SELECT * FROM ( SELECT > T1908.C1,C1000000161,C1000000018,C1000000019,C1000000000,C303497300,C1000000164,C7,C1000000217,C1000000218,C1000005261,C1000003009 > FROM T1908 WHERE (T1908.C1000000161 = 'INC000000239686') ORDER BY > C1000000161 DESC, 1 ASC ) WHERE ROWNUM <= 9001 > > Notice the difference in the clause after WHERE . > > When I run the first sql at the db level it takes between 60-90 seconds. > When I run the modified sql below it returns in seconds just like the INC > search: > > SELECT * FROM ( SELECT > T1908.C1,C1000000161,C1000000018,C1000000019,C1000000000,C303497300,C1000000164,C7,C1000000217,C1000000218,C1000005261,C1000003009 > FROM T1908 WHERE (T1908.C800021100 = 'KSR000000304374') ORDER BY > C1000000161 DESC, 1 ASC ) WHERE ROWNUM <= 9001 > > > Where would this SQL statement live in Developer Studio. > > 1. Ran client side logs on AL, Filters and the other boxes checked off > and nothing show up in my client side logs > 2. I have search and read several Active Links but none of them have the > SQL statement > 3. Did the same for filters > 4. Searched menu guides > > Currently the DBA is out for the Holiday and can not contact him. > > Remedy 7.6 > Oracle back end > > _____________________________________________________________________________________ > > > John Atherly | APC by Schneider Electric | Information, Process & > Organization (IPO) | Remedy Administrator / Developer > Phone: +305-266-5005 ext. 237 | > Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 > Waterford Way, Suit 850, Miami, FL 33126 USA > *** Please consider the environment before printing this e-mail > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
