Originally posted by aspdba
try giving

select sex from mytabs where sex='M'
Which will obiviously do Index FFS..

Anand :

i am not seeing the point why index is created..coz in most of the cases Sex M Or F will equally be divided..or rather M will silightly be more than F in any organization...

So when data is/rather will be spread across more then 20% of blocks in a table..it will do an FTS ( which is much efficient )

Abhay.