Did you check the sort order set on the table? Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office of Information Technology Services Service Delivery Division ITSM & ITAM Services Office: 919-754-6543 ITS Service Desk: 919-754-6000 jennifer.me...@nc.gov<mailto:jennifer.me...@nc.gov> http://its.state.nc.us<http://its.state.nc.us/>
E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Garrison, Sean (Norcross) Sent: Friday, July 15, 2011 4:06 PM To: arslist@ARSLIST.ORG Subject: Asset Management Console is slow ... trying to index/tweak query with no luck ** Hello ARSListers, I was wondering if you guys had done any tweaking on the asset management console and what suggestions you could make. I have the following query: SELECT * FROM ( SELECT T1262.C1,C210000000,C7,C200000005,C179,C200000007,C240001008,C240001003,C200000001,C260100004,C490021100,C200000020,C200000003,C200000004,C240001002,C260000001,C400129200,C240001005,C1000000150,C8,C400079600 FROM T1262 WHERE ((T1262.C400127400 = 'BMC.ASSET') AND (1 = 1) AND (T1262.C7 >= 3) AND (T1262.C7 <= 3) AND (1 = 1) AND (1 = 1)) ORDER BY 1 ASC ) WHERE ROWNUM <= 51 Which is generated from the out of the box asset management console when it first loads. It is taking ~51 seconds for this query to run. If I change it to this: SELECT * FROM ( SELECT T1262.C1,C210000000,C7,C200000005,C179,C200000007,C240001008,C240001003,C200000001,C260100004,C490021100,C200000020,C200000003,C200000004,C240001002,C260000001,C400129200,C240001005,C1000000150,C8,C400079600 FROM T1262 WHERE ((T1262.C400127400 = 'BMC.ASSET') AND (1 = 1) AND (T1262.C7 >= 3) AND (T1262.C7 <= 3) AND (1 = 1) AND (1 = 1)) ) WHERE ROWNUM <= 51 The query takes ~ 7 seconds to run. I have double checked all of the "Sort Order" settings for BMC.CORE:BMC_BaseElement, table, and AST:BaseElement to no avail. I can't seem to get Remedy to remove the "ORDER BY 1 ASC" part. On a side note I have found that this form is also using the "AST:BaseElement". I tried changing it to "BMC.CORE:BMC_BaseElement" so that it does not use the join. That doesn't do much either. I have also tried creating an index on base element to include the following fields when searching BMC.CORE:BMC_BaseElement: Request ID, InstanceId, DatasetID, and Status That didn't seem to speed it up either. Any help/suggestions? Thanks, Sean _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"