I had a customer call and complain that a select distinct statement was taking over 10 minutes to run and they thought that was to long. The table they are running the query against does have over 600 million rows so it is not a small table but it is partitioned. So I started looking into it and I found that the column that they wanted the distinct values for was not indexed. I created that index and now I am down to under 2 minutes. Proper indexing to the rescue again. Take a look at the queries that developers are complaining about and just see if you can do any optimization at the database level before tossing code back to them. 90% or more of the time it is code but that does not mean we can not try to help out.