When a routine name, index type name, or user-defined type that is not qualified explicitly with an authorization identifier is to be searched, a schema path determines the order in which different schemas are searched.
In the case of an index type name or a user-defined type name, if the target schema does not contain an index type name or a user-defined type name, the next schema is searched.
In the case of a function name, if executable candidate functions are not found according to the rules for determining the function to be called, the next schema is searched. For the rules for determining the function to be called, see 2.20 Function calls.
Schemas are searched in the following order:
In a specification that is not qualified with an authorization identifier, a schema path is applied to the referencing of defined routine names, index type names, and user-defined type names.