Index wizard is asking me to Knock of NUPI's created my other "index artists" ..

Analytics
Enthusiast

Index wizard is asking me to Knock of NUPI's created my other "index artists" ..

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 ?

3 REPLIES
Enthusiast

Re: Index wizard is asking me to Knock of NUPI's created my other "index artists" ..

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.

Teradata Employee

Re: Index wizard is asking me to Knock of NUPI's created my other "index artists" ..

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.

Enthusiast

Re: Index wizard is asking me to Knock of NUPI's created my other "index artists" ..

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.