公开(公告)号：US20230117461A1

公开(公告)日：2023-04-20

申请号：US17451047

申请日：2021-10-15

Applicant: Oracle International Corporation

Inventor： Krishna Kantikiran PASUPULETI ,  Mohamed Ziauddin ,  Hong Su ,  Sunil P. Chakkappen

IPC: G06F16/2453

Abstract: Disclosed is an approach for applying fine-grained hints to obtain optimal control over error handling during query compilation. Using fine-grained hints causes less disruption to the query plans generated by the optimizer as they constrain specific features while retaining scope for the rest of the optimizer functionality. This approach provides a query plan of better quality that avoid errors, particularly in comparison to coarse-grained approaches that restrict processing to earlier database versions or which disables cost-based processing.