Hi,
Gaining of space will depend on following
- no of deleted rows
- height
After validating the index you can check its space stats, and can calculate space used by per row. than by using some maths u can get the IDEA of the space that u'll gain after rebuilding.
Exact match is not possible....
Any other answers from gurus.....




Reply With Quote