ANALYZE_STATISTICS is a DDL operation that
auto-commits the current transaction, if any. The ANALYZE_STATISTICS function
reads a fixed, 10 percent of disk contents to aggregate sample data for
statistical analysis. To obtain a larger (or smaller) data sampling, use the ANALYZE_HISTOGRAM function, which lets you
specify the percent of disk to read. Analyzing more that 10 percent disk space
takes proportionally longer to process but results in a higher level of
sampling accuracy. ANALYZE_STATISTICS is supported on local temporary
tables, but not on global temporary tables.
For more information: Click Here
No comments:
Post a Comment