Avoid expensive queries

Some queries can, and should, be avoided. Two examples:

SELECT DISTINCT nonIndexedCol FROM HugeTable
 
SELECT * FROM HugeTable ORDER BY nonIndexedColumn

See Prevent the user from issuing expensive queries.