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

Home -> Community -> Usenet -> c.d.o.server -> Re: optimal sql

Re: optimal sql

From: Christoph Seidel <chris666.seidel_at_gmx.de>
Date: Wed, 11 Dec 2002 10:31:31 +0100
Message-ID: <at70mn$10s3j4$1@ID-143718.news.dfncis.de> 





Hanne Iren Midttun wrote:



>>> Make statistic in your production database (analyze or dbms_stats)

>>> and transfear the statistic to your test database.

>>

>> how can i do this?

>

> ie:

>



http://www.oracle-base.com/Articles/8i/CostBasedOptimizer(CBO)AndDatabaseSta
tistics.asp


> Look under the headline: Transfering Stats




ah, really cool!
Received on Wed Dec 11 2002 - 03:31:31 CST












Original text of this message













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