When a cardinality=1 single-column index beats the compound index

This post is also available on my blog. (한국어 버전은 여기)