>From what I have noticed, ARServer is oblivious to indexes and does not optimization any SQL statements for usage of indexes.
That is why it is up to the developer(s) to use queries appropriately... Thanks-n-advance; HDT Platform Incident / Problem Manager & Architect Robert Molenda IT OS PA Tel: +1 408 503 2701 Fax: +1 408 503 2912 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your actions. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, August 17, 2007 10:55 AM To: [email protected] Subject: Re: ITSM 7 indexes 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_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 ________________________________ Looking for a deal? Find great prices on flights and hotels <http://us.rd.yahoo.com/evt=47094/*http:/farechase.yahoo.com/;_ylc=X3oDM TFicDJoNDllBF9TAzk3NDA3NTg5BHBvcwMxMwRzZWMDZ3JvdXBzBHNsawNlbWFpbC1uY20-> with Yahoo! FareChase. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
