It was a complex Business Objects report with some > 30 joins and instead of coming up with some sort of Join Index recommendation I Wiz is asking me to drop a bunch of NUSI's that are'nt getting used and says it will improve the system performance 15%. I dont follow how dropping indexes that have no relevance to queries could manage to improve performance. any thoughts on this folks ?
Any takes ..? Dieter or any other knowledgable person . Indexes lying around unused for 1 report might be getting used other places . So how can they impair performance in places where don't plan on being used.
System performance includes update/ETL performance.
If there are workloads that were not supplied to index wizard, then it certainly is possible that those workloads might make use of the index.
Thanks Todd. I see - that point. But there's nothing so much so that these were factors that'd affect the present query in any manner. This is what I had in mind - thanks for confirming the same.