Stored procedures, especially if you think the data returned by the query will be very small compared to all the data in the tables.