Archives of the TeradataForum
Message Posted: Mon, 15 Dec 2008 @ 09:05:29 GMT
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.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|