A combination of a one-level index search and a expression that is not otherwise in the index can result in full scan, rather than using the one-level index.