Hi Gurus ,
I am on Oracle 10.2.0.2.0.
one of my tables is 30GB in size while three indexes on this tables is contributing to 147GB .
Index1 is 72640M
Index2 is 43304MB
Index3 is 31232MB.
how do i find if the table is fragmented ?
will exp/imp of the table without the indexes will be faster or move table ?
will rebuilding index be faster or drop and recreate it .
how much of temp space should i consider for this activity . Currently it is 25G.
Kindly request your advice to carry out this activity .
Regards,
DBApps