hi,
I think...


count(*) does a fast full index scan..as it just needs the count rather than the data..so reading the index would be sufficient.

try giving

select sex from mytabs where sex='M'