Rebuilt Oracle index and update statistics.
Posted on 2013-06-10
I come from MSSQL background, may I know if it is the same concept of Oracle to first rebuilt index and then update statistics?
From the Oralce 10g and 11g management console to:
1) what is the command/script to rebuilt all index/rebuitl index of some./all table.
2) what is the % of defragementation of the index befoer we should rebuilt for Oracle ? any online rebuilt option and what is it is ?
3) what is the script to update the statistis of all index?