When you get the error “Non-selective query against large object type”? how to resolve it

When you get the error “Non-selective query against large object type”? how to resolve it

Whenever an object has greater than 100K records any query on that object must be “selective”. For a query to be selective it must have enough indexed filters (where clauses) so that less than 10% of the records (in our example 10K) are returned before applying the limit statement