Hi John, The ARS has no way of knowing what fields are indexed if you do not do it from the Admin Tool and hence the indexes created from the database level will not get utilized from the application except if you run a Direct SQL from ARS.. Direct SQL's are not really evaluated from the ARS and the ARS throws whatever SQL statement you type directly to the database and fetches results if any. So the database would use those indexes.
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of john rosquist Sent: Friday, August 17, 2007 10: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_5 9_69_87_106_111] ON [dbo].[T688] ( [C1000000001] ASC, [C1000000018] ASC, [C1000000019] ASC, [C1000000056] ASC) INCLUDE ( [C1],[C4],[C7],[C179],[C200000006],[C200000012],[C260000001],[C1000000010],[ C1000000017], [C1000000020],[C1000000022],[C1000000025],[C1000000035],[C1000000054],[C10 00000346], [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 ---------------------------------------------------------------------------- -- Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. __20060125_______________________This posting was submitted with HTML in it___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.0/957 - Release Date: 8/16/2007 1:46 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
