Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> exp: why have statistics=estimate option?

exp: why have statistics=estimate option?

From: Chuck Hamilton <chuckh_at_dvol.com>
Date: 1996/12/30
Message-ID: <32c80c9b.17843869@n5.gbso.net>#1/1 







Maybe this is a dumb question, but why even have the
'statistics=estimate' option in the export utility? When a table gets
imported, the _exact_ number of rows imported is already available.
Why not just use that number to populate DBA_TABLES.NUM_ROWS instead
of going through the time consuming process of issuing an ANALYZE
TABLE command?

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!


Received on Mon Dec 30 1996 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US