Displays the list of all user objects whose collections are explicitly excluded from Automated Statistics Management.
Syntax
REPLACE PROCEDURE TDSTATS.SelectAllExcludedObjects () ... ;
Output
| Column | Description |
|---|---|
| ObjectType | Type or level of exclusion:
|
| DatabaseName | Excluded database or the database containing the excluded table. |
| TableName | Table to be excluded if ObjectType is T. For details, see the ObjectType output parameter. |
| CreatedTimeStamp | Time when the object was excluded. |
| CreateUser | User who imposed the exclusion. |
Usage Notes
Returning Result Set
The output of this external stored procedure is in the form of a stored procedure dynamic result. That is, the external stored procedure can return result sets to the client application or to the caller of the external stored procedure (in addition to consuming the result sets itself) upon completion of the external stored procedure.
For more information about stored procedure dynamic result sets, see Teradata Vantage™ - SQL External Routine Programming, B035-1147.
Example: Using SelectAllExcludedObjects
The following example shows how to retrieve a report of all excluded objects defined for the Automated Statistics Management feature.
CALL TDSTATS.SelectAllExcludedObjects;
Result:
*** Query completed. 3 rows found. 6 columns returned. *** Total elapsed time was 1 second. ObjectType DatabaseName TableName CreatedTimeStamp CreateUser ---------- ------------ --------- ---------------- ---------- T PERSONNEL PROJECT 2010-09-01 23:46:29 DBC T PERSONNEL DEPARTMENT 2010-09-01 23:48:34 DBC T SALES SUPPLIER 2010-09-05 21:31:35