Re: Selectivity of Indexes
Quote:
Originally posted by majub
Dear Julian,
Thanks for your reply. How can I collect the histogram for the bitmap indexed column? Please advise.
Thanks and regards
Maju Bellamin
Bahrain
Assume that you have the table EMP with the column DEPT_ID which has a bitmap index on it.
If you want to generate the table statistics on EMP and column statistics on the column DEPT_ID with maximum number of buckets being 90, you run:
Code:
ANALYZE TABLE emp COMPUTE STATISTICS FOR TABLE FOR COLUMN dept_id SIZE 90;
Oracle has a default number of buckets equal to 75. For default value you simply run:
Code:
ANALYZE TABLE emp COMPUTE STATISTICS FOR COLUMN dept_id;