Bitmap and B-Tree Indexes

Bitmap Index: It is good for OLTP Systems and if the data have many distinct values,more cardinality values.

Example: Empno has many distinct values.

B-Tree Index: It is good for DSS System and if the data has low distinct values,less cardinality values.

Example: Gender,Martial Status columns values.

Process:

1.Create Indexs -- Bitmap and B-tree Indexes.

2.Analyze the table for stats.

3.Finding the size of the index and clustering factor.

4.Set Autotrace.

5.Retrieve queries.

6.Execution Plan.

7.Statistics.