Release 11.9.2 introduced extensive changes in query processing and optimization. Statistics became more granular and accurate. Some of these changes may result in the optimizer creating different query plans when executing old applications. These changes are discussed in the following sections: