Avoid expensive queries Some expensive queries can, and should, be avoided.

Two examples:

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

See .