When I perform explain plan of a query, the plan shows with Table Access Full for a table.
I usually try to force an index whenever explain plan shows Table Access full covering its fields present in where clause.
In spite of creating an binary index for the where clause it does'nt pick the index when testing with explain plan.
Why it does'nt pick an index sometimes but picks indexes other times.