I want to know when should we run reorg rebuild on a database or a table.
If i have run the reorg rebuild 3-4 months back and running update index stats regularly, when should i run reorg now.
What parameter will tell me when is the time to run reorg rebuild ? Please provide details.
How optdiag can be useful here ?