The query optimizer decides how to access the data and looks for optimal way to retrieve the data, using different execution paths.