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 |
| ||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.