Sam >SQL> exec dbms_stats.set_table_stats('GENERAL','GUROUTP'); With this command Oracle sets some default values. You have to use dbms_stats.gather_table_stats instead... HTH Chris -- //www.freelists.org/webpage/oracle-l