Useful uses of statistics

 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/ Received on Wed Jan 17 2001 - 16:41:53 CST