How do you reorg a table?
How do you reorg a table? Step By Step Blueprint For Oracle Table Reorg – Index RebuildStep1 – Stop Application. Step2 – Login To The Database. Step3 – Run PRE-Checks. Step4 – Generate Reorg Scripts. Step5 – Rename Tablespaces To _OLD. Step6 – Create New Tablespaces. Step7 – Run the maintenance scripts. Step8 – Verify Index Status. What is Reorg and Runstats in DB2? runstats is for collecting indexes and tables statistics information which to enable the DB2 optimizer to generate efficient access plan. reorgs is for reorganizing tables and indexes. How do I know if my table needs reorg?...