For a given SQL statement, there are often multiple access path choices, and the different access paths usually have different performance characteristics.

Note that we categorically argue against setting up multiple SPNs so that SSO access to the application will work, regardless of the access path.

The optimizer compares the cost of each candidate access path based on the information from multiple inputs, for example, see the following.