It could be that you don't have enough data for the query analyzer to see a problem. Be careful assuming that when developing applications that search data that your developer tests will hold in production. Developers often test with so few records that problems with indexes and queries aren't seen then in production they bring applications to a stop. I've seen poorly constructed tables and queries take over a day to run then apply an index, rearrange the query, and the query looking for the exact same data take a few minutes. If you are performing searches often, add indexes, structure your query so that the filter that excludes the most records is the first filter in the list. This is one of the reasons I always like to see the actual data structure and run some test queries before I develop applications that heavily access data through queries.This is one reason that DBA's make the kind of money they do.