iBinc
asked on
Validate Partitioned Table Indexes
How can you determine if you need to rebuild indexes within a partitioned table? (Oracle)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
not necessary in oracle
unless you want to move the index to another tablespace
or a lot of data got deleted and you want to retrieve empty space
the optimizer uses statistics to determine the cardinality
statistics are refreshed based on how many changes have occured on the table