Wanted to know the algorithm used when an index is utilized on the database. Not when you should use this index over that index, but what the optimizer is doing when an index is used.
Sigiloso
I answered the question from experience when to use what index depends on the cardinality.