an approach where the database automatically estimates the cost of different execution strategies and chooses the most efficient one.