Describe how a query optimizer determines the most efficient path to get data from a database.
a) The query optimizer selects the path with the most available database connections.
b) The query optimizer considers the shortest physical distance to the data.
c) The query optimizer evaluates the cost of different execution plans and selects the one with the lowest cost.
d) The query optimizer chooses the path that retrieves the most data in a single query.
