title: Does MySQL make full table scan when result not found in other indexes
body: <p>Lets say we have an ordinary table with the following structure: id column which is primary key, several other columns each of which has index key (single index key) and one column with unique key (instead of index key).</p>
  
  <ol>
  <li><p>If we search by one of the columns with index key and no result is found in the index (lets assume that mysql will use the index for the search) will mysql do full table scan to verify that there is no result matching the criteria?</p></li>
  <li><p>Almost the same scenario like the above but this time instead of searching by column with index key it will search by the column with unique key. Will mysql do full table scan?</p></li>
  </ol>
  
  <p>Thanks in advance for the answers!</p>