Rebuild indexes & gather statistics after table shrink.
July 6th, 2008 Posted in Oracle Tip
Just a quick tip. When you finish a table segment shrink, it is a good practice to rebuild any indexes on that table as well as gather statistics on that table. These tasks help Oracle to create a better execution plan for the SQL query related to the table.
Tags: shrink
