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.