Thanks for your response Sybrand
I have got a few more questions:
- exec dbms_stats.gather_schema_stats('XXX', cascade => true);
Does this command exactly the same as the one I show in the previous
decribed method (1)?
- Under which user should I run this command (schema owner or the
sytem user (as SYSDBA) )?
-I thought that some results were written to the table
DBA_TAB_MODIFICATIONS? Is this true because no records can be found.
- I did not understand yor answer about the parameter optimizer_mode
FIRST_ROWS " in the ini file. Does it make use of this parameter?
Thanks
Received on Sun Feb 23 2003 - 05:00:01 CST