if the table is too small and can fit into one single block then i think it will go for full table scan no matter all columns are indexed