|
|
|
|
|
|
| Re: Questionable statistics in Exporting [message #63149 is a reply to message #63148] |
Tue, 14 September 2004 12:23  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
quoting the docs
STATISTICS
Default: ESTIMATE
Specifies the type of database optimizer statistics to
generate when the exported data is imported. Options
are ESTIMATE, COMPUTE, and NONE. See the Import
parameter STATISTICS and Importing Statistics.
In some cases, Export will place the precalculated
statistics in the export file as well as the ANALYZE
statements to regenerate the statistics.
However, the precalculated optimizer statistics will
not be used at export time if a table has columns with
system-generated names.
The precalculated optimizer statistics are flagged as
questionable at export time if:
There are row errors while exporting
The client character set or NCHAR character set does
not match the server character set or NCHAR character
set
A QUERY clause is specified
Only certain partitions or subpartitions are exported
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
