VALIDATE_STATISTICS
Validates statistics in the XML file generated by the EXPORT_STATISTICS command.
Syntax
VALIDATE_STATISTICS ( 'XML_statistics_file' )
Parameters
XML_statistics_file |
Specifies the path and name of the XML file that contains the statistics you want to validate, type VARCHAR. |
Privileges
Usage Considerations
-
IMPORT_STATISTICS imports only valid statistics. If the source file has invalid statistics for a specific column, those statistics are not imported and a warning occurs. To identify the invalid statistics, run VALIDATE_STATISTICS.
Example: Valid Statistics
The following example shows the results when the statistics are valid:
=> SELECT EXPORT_STATISTICS('cust_dim_stats.xml','customer_dimension'); EXPORT_STATISTICS ----------------------------------- Statistics exported successfully (1 row)
=> SELECT VALIDATE_STATISTICS('cust_dim_stats.xml'); VALIDATE_STATISTICS --------------------- (1 row)
Example: Invalid Statistics File
The following example shows the results when some of the statistics are invalid. For example, the 'distinct'
, 'buckets'
, 'rows'
, 'count'
, and 'distinctCount'
attributes cannot be negative numbers. Open Text Corporation recommends that you rerun ANALYZE_STATISTICS on this table to create valid statistics:
=> SELECT VALIDATE_STATISTICS('/stats.xml'); WARNING 0: Invalid value '-1' for attribute 'distinct' under column 'public.t.x'. Please use a positive value. WARNING 0: Invalid value '-1' for attribute 'buckets' under column 'public.t.x'. Please use a positive value. WARNING 0: Invalid value '-1' for attribute 'rows' under column 'public.t.x'. Please use a positive value. WARNING 0: Invalid value '-1' for attribute 'count' under bound '1', column 'public.t.x'. Please use a positive value. WARNING 0: Invalid value '-1' for attribute 'distinctCount' under bound '1', column 'public.t.x'. Please use a positive value. VALIDATE_STATISTICS
---------------------
(1 row)
Example: Invalid Statistics File
The following example shows the result when the statistics file is invalid:
=> SELECT VALIDATE_STATISTICS('/home/dbadmin/stats.xml'); VALIDATE_STATISTICS ---------------------------------------------------------------------------- Error validating statistics file: At line 1:1. Invalid document structure (1 row)