Surely your choice of index for the large range could have been better?  Yes the highly specific reversed order may be better for a particular lookup, but for a ranged lookup over all 4 levels surely an index in order would be better?  After all, in this example you will need to go through ALL of the top 3 levels before you acquire any level of usable index?  Seems pretty inefficient to me.