Excellent point about the statistics. I recently discovered that alter table move in Oracle 9 (9.2.0.5) seems to delete the statistics. I do not recall that from Oracle 8. At 05:26 PM 9/8/2004, Reardon, Bruce (CALBBAY) wrote: >Also, something others may know but I ran into recently. >When you move a table, posts normally point out that indexes will need = >to be rebuilt (as the post below does). >You also need to recreate statistics (by your method of preference - = >dbms_stats gathering, analyze or dbms_stats setting) on the table and = >indexes. >HTH, >Bruce Reardon Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/