The Data Summarization Viewer displays summary statistics for the selected table or view.
Note: To ensure good performance, all statistics are calculated on a sample of the data. For information about calculating statistics on a sample, see Calculating Statistics.
The viewer displays the Sample Count and the Attribute Count for the table or view.
Attributes are summarized in a grid. You can sort the items in the grid by clicking any column header. For all attributes, the grid displays the following:
NUMBER
, FLOAT
, CHAR
, VARCHAR2
, etc.)For attributes with numerical datatypes such as NUMBER
or FLOAT
, the viewer displays the following additional information:
If the table or view is not in transactional or multi-record format, the viewer also displays:
NULL
values for the attribute in the sample.To view the histogram of an attribute, select the attribute and click Histogram.
To close the viewer, select File | Exit from the menu bar.
Copyright © 2006, 2008, Oracle. All rights reserved.