New Stats Collection Process in Teradata 14.10

Database

New Stats Collection Process in Teradata 14.10

Is there any relationship between ObjectUseCount feature and new stats collection feature in Teradata 14.10?

If so, what is it?

Thanks in Advance!

2 REPLIES

Re: New Stats Collection Process in Teradata 14.10

Hi Kishore,

Hope this link can help you.  In Teradata 13.10, this piece was  there. So helping to identify objects for drop is same:

Recommended for drop

This column is visible only when an index analysis is performed on a workload. This column shows “YES” if the index was recommended for DROP when the workload was analyzed.

In 14.10, Teradata Index Wizard, report

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/Database_Administration_Tools/B03...

insert, update, delete use counts are in 14.10.

Re: New Stats Collection Process in Teradata 14.10

Thanks Raja.

Hope scheduling this report over a period of time will help us identify indexes that are not needed  and take appropriate action.