On Tue, Mar 31, 2009 at 10:59 AM, Matt Jarvis <[email protected]> wrote: > Trying to track down something of a bogged down query and came across > the Index Tuning Wizard. Great tool, but what it recommends to do with > my tables as far as I can tell I've already done i.e. indexing. > > Is it normal for the thing to tell me what I already know? Or I wonder > if I'm not looking at my indexes correctly... --------------------------
I didn't like the output that the tuning process gave the two times I used it. I got more indexes on a single column instead of reducing the # of indexes and making combo column indexes instead. Getting a pricey tool for server management will tell you beyond all doubts that some of your process are causing problems. Is it Inserts with index problems on a specific table? Do you have a transaction that is locking tables within a SP? -- Stephen Russell Sr. Production Systems Programmer Web and Windows Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
