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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
