|
Archives of the TeradataForumMessage Posted: Mon, 15 Dec 2008 @ 09:05:29 GMT
Hi Rit, Let's start with some basic info. - what commands does your SP generate and/or execute ? - how big is the table that you're collecting statistics on ? SELECT SUM(CURRENTPERM) FROM DBC.TABLESIZE WHERE DATABASENAME = 'name of database' AND TABLENAME = 'name of table'; - how many columns/indexes are statistics being collected on ? HELP STATISTICS 'name of database'.'name of table'; - what release of Teradata are you using ? SELECT * FROM DBC.DBCINFO; Collecting statistics on a column often requires a full table scan (FTS). If it takes 30 minutes to do an FTS and you're collecting stats on 18 columns that will take about 9 hours. Cheers, Dave Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||