0 Replies Latest reply: Jan 2, 2013 2:43 AM by Sweety RSS

    Reclaim/Shrink space of tables and indexes after bulk data deletion


      We have plan to delete large tables with DELETE stmt. And then use aler table shrink space command to remove defragmentation. So next step require to rebuild index or shrink index. For now we have used rebuild index which is taking considerable longer time. Now i have two questions.

      1) With ALTER TABLE SHRINK SPACE CASCADE, does it recovers spaces for tables and indexes (associated dependent objects). If yes, we need not do any special operation for INDEXES.

      2) If not, which one is better REBUILD INDEX OR SHRINK SPACE INDEX.

      Please let me know your views soon.

      Thanks in advance