You shoud always try to add indexes thru the Admin tool. If you don't, then the Remedy API will not know about them
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of john rosquist Sent: Friday, August 17, 2007 9:27 AM To: [email protected] Subject: ITSM 7 indexes ** I am looking at adding indexes to my ITSM 7 application (ARS7.02) on SQL 2005. Does anyone know if it is still recommended to added the indexes via the admin tool, or can you use the underlying database to add indexes. I remember from the tuning class that you should use the admin tool, but I want to see if this is still the case. Based on the SQL profiler result, adding more information to the leaf, should improve performance. Note( T688 is CTM:People, 1,18,19,56 are company, ln, fn, Phone). CREATE NONCLUSTERED INDEX [_dta_index_T688_5_19947593__K46_K52_K53_K88_1_4_7_15_16_18_28_50_51_54_ 56_59_69_87_106_111] ON [dbo].[T688] ( [C1000000001] ASC, [C1000000018] ASC, [C1000000019] ASC, [C1000000056] ASC) INCLUDE ( [C1],[C4],[C7],[C179],[C200000006],[C200000012],[C260000001],[C100000001 0],[C1000000017], [C1000000020],[C1000000022],[C1000000025],[C1000000035],[C1000000054],[C 1000000346], [C1000000846]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY] Any ideas? Thanks, John Rosquist Senior Consultant Windward Consulting Group _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
