|
Archives of the TeradataForumMessage Posted: Thu, 15 Mar 2012 @ 19:46:50 GMT
TD 13 on Windows 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. 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? Thanks, James Park
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||