Mark, Indixing is too unique for each environment to have simple rules how to do it. I allways distinguish new system from loaded system. New system is not a good place for analysis, you can leave it as it is out-of-the-box. When you load your system with data and have it in production for awhile, again, all relative based on your daily volumes (but I'd say 6-9 months from deployment), it is a good time to launch a small "fine tunning" project. The best source to start with are the "top sql" at the database level - pretty much the heaviest hitters in your app. Forget about the rules, there are no common rules out there that apply to everyone. It is all give and take - you add index, then you maintain it, again, no rules apply, but it is measurable in db performance stats, so you can actually find if you are gaining or loosing. Regards,
Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ----- Original Message ----- From: Brittain, Mark Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, September 17, 2009 11:30 AM Subject: Indexing help ** Good morning, I think I inherited a mess and need some help with indexing. If I have an index Status Assigned Group Assigned Person And the query is Assigned Group and Assigned Person does the index get ignored because Status was not used? What if I have similar indexes like these Index 1 Status Assigned Group Assigned Person Index 2 Assigned Group Index 3 Assigned Person Are these redundant? Also is there and good information out there that really gets into the nuts and bolts of indexing? Thanks Mark ____________________________________________ Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
