Why we can't use a compound index with two or more independent range conditions?

Hi guys,

I have asked my question in stackoverflow. But seems there is no one to answer. Can anyone help me?