Archives of the TeradataForum
Message Posted: Fri, 10 Apr 2009 @ 19:29:21 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|