How to fetch table statistics in BODS

[former_member186897]

The simplest way of fetching table statistics would be reading the stats from repository Metadata table.

This information could be used while building the framework for a Job in DS and could be helpful in performance optimization. The following SQL query selects some of the attribute values related to loading of a target table in a given datastore. You may add more attributes values depending on your requirement.

Select your repository database and execute the following SQL statement. Before executing just update the below query with a valid datastore name and table name for which you want to check the stats.

SELECT
TABLE_NAME, TABLE_OWNER,DATASTORE, TABLE_ATTR,TABLE_ATTR_VALUE
FROM ALVW_TABLEATTR
WHERE DATASTORE= 'datastore_name'
AND TABLE_NAME = 'table_name'
AND TABLE_ATTR IN (
'Date_last_loaded',
'Total_Number_Of_Rows_Processed',
'Number_Of_Rows_Rejected',
'Number_Of_Inserts',
'Number_Of_Updates',
'Number_Of_Deletes',
'Elapsed_Time_For_Load',
'Loader_Is_Template_Table');