There is quite the scenario that the Oracle Cost-Based Optimizer (CBO) uses when deciding when to use indexes to process your SQL. I go into this in great detail in my SQL Performance Tuning course (click here for details).
This is a companion discussion topic for the original entry at https://blog.toadworld.com/2017/03/20/index-clustering-factor-and-oracle