i am planning to rebuild index online. my DB version is 10.2.0.3. i need some suggestion to rebuilding index.
how to find which index need to be rebuild?
what cases we need to rebuild indexes?
how to rebuild local indexes (partitioned indexes)?
how to rebuild global indexes?
what are the precautions i need to take while rebuild index online.
is there any negative impacts if i rebuild the index online?
please any one guide me to rebuild indexes.