UNLOAD STATISTICS
Unloads
database statistics to a text file.
SYNTAX
| object_list |
List
of database objects to unload statistics data for. |
| file_name |
Name
of the ASCII text file that statistics data will be saved in. |
DESCRIPTION
The UNLOAD
STATISTICS command unloads database statistics into an ASCII text file.
Once the data is unloaded into a file, you can examine the statistics
data. You can also edit the file and load the desired statistics data
back into the database. To execute the UPDATE STATISTICS command, you
must have DBA or SYSADM security privileges.
You can
load statistics information for the entire database, or you can load statistics
information for only one or more tables. For each table, you can specify
whether you want to load the table statistics information, the column
statistics information, the index statistics information, or a combination
of the three.
For table
data, DBMaker records statistics on the number of pages, the number of
rows, and the average row length of sampled rows in a table. For column
data, DBMaker records statistics on the number of distinct column values,
the average column length, the low value, and the high value for all sampled
values in a column. For index data, DBMaker records statistics on the
number of index pages, the number of index tree levels, the number of
leaf pages, the number of distinct key values, the number of pages per
key, and the cluster count for the index.
Object List
EXAMPLE
The following
example unloads all statistics data for the database to the file stat.dat.
UNLOAD STATISTICS TO stat.dat
|
RELATED COMMANDS
<
TERMINATE DB | Contents
| UPDATE >
|
