 |
 |
Archives of the TeradataForum
Message Posted: Fri, 30 Aug 2013 @ 16:29:52 GMT
| Subj: | | Re: How to check whether PI has STATS collected |
| |
| From: | | Geoffrey Rommel |
| | All I want to check whether we can check whether or not STATS are collected on PI(Not other index or columns) of a table by passing
TableName and DatabaseName? | |
select ...stuff...
into :sp_variable
from dbc.IndexStats [or other view with stats information, depending on your release]
where databasename = :DatabaseName ?and tablename = :TableName ?and IndexNumber = 1;
If IndexStatistics is non-null on at least one row, stats have been collected.
| |
