Oracle can gather some statistics automatically while creating or rebuilding a B*-tree or bitmap index. The COMPUTE STATISTICS option of CREATE INDEX or ALTER INDEX … REBUILD enables this gathering of statistics.
COMPUTE
STATISTICS
CREATE
INDEX
ALTER
REBUILD
Name (required)
E-mail (will not be published) (required)
Website
Notify me of follow-up comments via email.
