All Forums Database
Kishore_1 208 posts Joined 03/10
14 Jun 2014
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!

Raja_KT 1246 posts Joined 07/09
15 Jun 2014

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/B035_2506_082K/2506ch07.33.08.html
insert, update, delete use counts are in 14.10.
 
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Kishore_1 208 posts Joined 03/10
15 Jun 2014

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

You must sign in to leave a comment.