FULL SCAN AND BITMAP INDEX SCAN!!
Hi all,
If i have a table with lots of record and a column having values 'MALE' and 'FEMALE' only. and i have to search with this coulmn in where clause.
so normal index on this column will be benificial or bitmap or no index.
is it true that a full table scan is considered over a normal index scan if a columns having lower cardinality values?
if it is so then why bitmap indexes are used b'coz they are also used for the columns with lower cardinality
Thanx in advance!!