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],[C1000000010],[C1000000017],
[C1000000020],[C1000000022],[C1000000025],[C1000000035],[C1000000054],[C1000000346],
[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
____________________________________________________________________________________
Need a vacation? Get great deals
to amazing places on Yahoo! Travel.
http://travel.yahoo.com/
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
