Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Transferring Prod Statistics...
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 Received on Tue Sep 15 1998 - 10:08:47 CDT