Archives of the TeradataForum

Message Posted: Thu, 15 Mar 2012 @ 20:55:20 GMT


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

Subj:		Re: Find tables to run collect statistics

From:		Dieter Noeth

JAMES PARK wrote:

I posted a question regarding collecting statistics before but would like to bring it up again. I think a user directed me to a website but I couldn't find it.

This one?

developer.teradata.com/...

As I run collect statistics for ALL TABLES(thousands tables both in PRD and DEV) every other week I think it is unnecessary and time and resource consuming especially for those tables that haven't been changed.

Is there a way or a SQL to find tables that have been changed (insert, delete, update) at a certain percent and need collecting statistics?

You can use my query to determine when stats have been collected last time, but there's no easy way to determine this percentage:

- it might be extracted from DBQL

- you might extend your load jobs to calculate it

- upgrade to TD14 :-)

I'm currently implementing a process for huge tables:

collect partition stats -> compare the new row/partition count to the previous one ->

collect stats when difference > x%

Dieter


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

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2012 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023