1 Reply Latest reply on Jan 10, 2020 7:33 PM by EdStevens

    To identify list of tables for which reorganization is required

    1248569

      Could you please provide a sql query to find list of tables on which re-org is required. Specify space could be released by re-org operation.

        • 1. Re: To identify list of tables for which reorganization is required
          EdStevens

          1248569 wrote:

           

          Could you please provide a sql query to find list of tables on which re-org is required. Specify space could be released by re-org operation.

          This is typically a fool's errand.  I'm sure you could find tables for which some space could be released back to the TS, but the next time you INSERT into the table (or even UPDATE resulting in growth of rows) you'll just have to go to the expense of re-acquiring that space.   Does a retail store re-organize their shelves as stock is sold, just to re-organize again as new stock comes in to replenish that which was sold?

           

          What is the real business problem you are trying to solve?