I tried to defrag my indexes on a particular table by trying REBUILD(DBREBUILD) & REORG(INDEXDEFRAG).
Don't know the reason it is taking more time to execute and I tried to see how much timeit may take, I Observer even after like 2 hrs of start time, it keep on executing.
What might be the reason and how can I get rid of this and defrag my Indexes?
I have to Defrag those Indexes, as we have user reporting about the reports taking more time to execute.
Will it work if I try to schecule a REORGNIZE the Indexes using the Maintanence Paln?