Thursday, September 27, 2007

Gathering Index Statistics

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.

No comments: