Yes, have a look at the procedures available in the dbms_stats package. Quoting Syed Jaffar Hussain <sjaffarhussain@xxxxxxxxx>: > Is there any way that we can set fake statistics to a particular > partiton of a partitioned table? > I would like to set fake statitics to a partition of a partition table. > > Thanks for your time. > -- regards Wolfgang Breitling Oracle 7,8,8i,9i OCP DBA Centrex Consulting Corporation www.centrexcc.com -- //www.freelists.org/webpage/oracle-l