Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Useful uses of statistics
Your right on target here. I've used statistics exports/imports to do this exact same thing and it works like a charm.
In article <94573g$orb$1_at_nnrp1.deja.com>,
fox <thewilyfox_at_my-deja.com> wrote:
>
>
> I am currently involved in the implementation of a data warehouse,
> potentially 3TB, and I am thinking
> about ways of performing future regression tests, I understand that
> statistics can be exported from
> 8.1.x databases and imported to other instances where they could be
> used to replicate the kind of
> execution plans that would be expected (I should have said that I
need
> to run regression tests etc. on
> smaller sanitised versions of the production db, cos I've run out of
> room). Has anyone experience of
> using imported statistics on subsets of a larger database, or am I
> completely missing the point of this
> facility, and it has no relevance to testing queries against smaller
> dbs to replicate the kind of plans that
> would be generated against the original. Any help would be
appreciated.
>
> Sent via Deja.com
> http://www.deja.com/
>
Sent via Deja.com
http://www.deja.com/
Received on Wed Jan 17 2001 - 19:51:49 CST