Re: new to CBO - statistics / explain plan question

What statistics do you have ?? If its

1. from SQL Trace, then TKPROF will tell you about the parsing and exec counts for each SQL. Tune SQL which are parsing a lot.
2. STATS PACK report: check parse ratio, wait events etc.

Statistics will tell you the problem area.

>>my question is :
>>if my test database contains NO data but only statistics, will the
>>output of "explain plan" be the same as on my customer's server ?

NO, MAY BE , Not SURE only you can tell Received on Mon Mar 27 2006 - 00:08:09 CST