In this statement : "select * from db where cnum = 'c'".

I want that query return only one record and the query stop after find one record. I don't want that the query scan all the database for it.

What I can append to this query to do it?