Re: Transferring Prod Statistics...

From: natwestccd <dave.hawkins_at_natwestccd.demon.co.uk>
Date: Thu, 24 Sep 1998 08:25:32 +0100
Message-ID: <906623520.16352.0.nnrp-07.c1ed0882@news.demon.co.uk>

dprentic_at_csc.com wrote in message <6tlvtv$3pe$1_at_nnrp1.dejanews.com>...
>Is there any way to transfer the statistics (or input them) into an
instance
>that does not have any data?
>
>I would like to be able to allow my developers the ability to do explains
and
>view realistic results (i.e. from prod stats) when using cost based
>optimization without having to store production volumes. In other words,
is
>there a way I can fake the explain function into thinking it is looking at
a
>production system when, in actuallity, there is no data?
>
>Any help would be appreciated.
>
>Regards,
>
>Don Prentice
>dprentic_at_csc.com
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

Oracle 8.1 (in beta at the momemt) allows that, otherwise the only other option is to recreate or recover your database in your test server, run the analyze command if you have recreated it, and truncate the tables releasing the storage............ Received on Thu Sep 24 1998 - 02:25:32 CDT