Re: Index advisor and system cross-reference files

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