minimizing response times for actions by choosing the most efficient query to achieve it
examining multiple ways of executing the same query and choosing the fastest option
parallel query processing-possible when working in multiprocessor systems overriding automatic query optimization-allows for query writers to preempt the automated optimization