You use the index to identify a subset of records and scan those for unindexed criteria. It's ok to fail if the indexed criteria are not selective enough. In f

You use the index to identify a subset of records and scan those for unindexed criteria. It's ok to fail if the indexed criteria are not selective enough. In fact it's usually preferable to a long timeout.