Its me again..!!
I have a fact table, below is some more information on it,
# Records Reserved (KB) Data (KB) Indexes (KB) Unused (KB)
579,126,119 389,356,128 247,399,656 141,672,088 284,384
For simplicity please assume every metric is above 100GB. except the unused KB.
There are 8 indexes on this table, i ran the 'index physical statistic report' and it recommends me to perform reorganize on 4 of the indexes and rebuild on the other 4. How to go about maintaining index ifor such tables?
We have nearly 1000 Business objects (reporting tool) reports reading this table
Thanks for all your help.