Are there any settings that we can use to turn off Index Advisor?

This may be a radical solution, but if the Index Advisor is not useful, ignore it. You're also free to clear the history any time you want. If it isn't providing useful information (and I'll agree with Rob, that's probably a PTF issue), why worry about it? If you're worried about the space taken, you weren't using the recommendations anyway, so clear the file.

If you do want to make use of it, you will find that it makes many, many recommendations. It still takes some analysis to determine what is significant (for me, that's the number of times the index was needed * the time the index takes to create on the fly). It takes further analysis to determine/consolidate multiple requests that can share the same access path (ie, a recommendation for a part number/branch plant index vs. a part number/branch plant/date index). There will always be some level of recommendations that are not worth following because every possible suggestion, if implemented, would slow database writes to a crawl. That's the nature of database administration--it's always a balancing act.

_____________________________________________________________________
Spirax-Sarco Engineering Plc. This e-mail has been scanned for viruses by Verizon Business Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.verizonbusiness.com/uk

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].