When should one use the compress option while creating a index .
In my have I have table with 52Million records .
OLTP database ..
40 distinct values are there in the column ..
Since being OLTP i cannot use BitMAP indexes ...
Under this condition Can I use the Index compress ..
What will be advantages ....
CREATE INDEX idx_EMP on EMP (DEPTNO) COMPRESS