 |
 |
Archives of the TeradataForum
Message Posted: Thu, 29 Aug 2013 @ 11:27:13 GMT
| Subj: | | Re: How to check whether PI has STATS collected |
| |
| From: | | narayan.murthy |
saurabh.c.srivastava wrote:
| | I want to use a query in stored procedure which should either say Yes(Y) or No(N). | |
| | 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? | |
You could try HELP stats, and then since it is a stored procedure you can check the return status.
| |
