Archives of the TeradataForum

Message Posted: Fri, 10 Apr 2009 @ 19:29:21 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Finding frequency of NUSI usage

From:		Madhumitha Das

Folks,

We have few dozen Secondary Indexes (NUSIs) built on some base tables (some are > 1TB in size). As tables are being populated with history, the NUSIs are getting bigger and the table updates are running longer.

What's the best and reliable way to find un-used NUSIs. If I see a NUSI in DBC.Indexes but not in DBC.DBQLObjTbl, can we safely assume that it's never been used?

Thanks for your help.

Madhu Das