Search Using at Least One Indexed Field

Whenever you perform a query, make sure that your view object's view criteria filter includes at least one indexed field in the predicate.

Especially when the amount of data is large, using at least one index to filter the data makes a meaningful difference in application query performance.

Note: Failure to use an index of any kind for your an application business logic query implies the database will perform a full table scan that can be a recipe for slow response times and unhappy end users.