HI,

I was asked to do the performance tuning for the new application .
the problem is there is really little data in test environment .

since there is very limited production data in test environment, I was
asked to emulate production statistics for the new tables.

all I know is production volumn of the tables ( cardinality) and some
idea of distribution in test environment (based on 20 rows data)



is there any existing formular to emulate statistics . ..

I just needed roughly emulation, as long as enough to create
production access plan.

any suggestion is really appreciated.

Thanks.

On 1/3/2012 2:42 PM, esther wrote:
objects on your test system with the stats that appear in the production
system. However, without some systematic emulation of your production
environment, you still may not get representative performance.

Larry E.

--- Posted via news://freenews.netfront.net/ - Complaints to news (AT) netfront (DOT) net ---