In case of concatenated index, if you are missing leading column then it'll not use the index.