Oracle SQL Profile在查询优化中的应用技巧

在现代企业中，数据中台、数字孪生和数字可视化技术的应用越来越广泛，而这些技术的核心离不开高效的数据处理和查询优化。在Oracle数据库中，SQL查询的性能优化是提升整体系统效率的关键环节。而Oracle SQL Profile作为一种强大的工具，能够帮助DBA和开发人员更好地理解SQL执行行为，从而实现更高效的查询优化。本文将深入探讨Oracle SQL Profile的使用方法及其在查询优化中的应用技巧。

什么是Oracle SQL Profile？

Oracle SQL Profile是一种用于分析和优化SQL查询性能的工具。它通过捕获和分析SQL语句的执行计划、访问路径、绑定变量使用情况等信息，帮助DBA和开发人员识别性能瓶颈，并提供优化建议。SQL Profile的核心作用是通过自动化分析，减少人工干预，从而提高SQL优化的效率和准确性。

SQL Profile的主要功能

1. 执行计划分析：通过捕获SQL语句的执行计划，帮助识别不理想的执行路径。
2. 访问路径优化：分析SQL语句的访问路径，建议更优的索引或全表扫描策略。
3. 绑定变量优化：优化绑定变量的使用，减少硬解析的次数，提升SQL执行效率。
4. 统计信息收集：提供详细的统计信息，帮助DBA更好地理解SQL语句的行为。

为什么使用Oracle SQL Profile？

在数据中台和数字可视化场景中，SQL查询的性能直接影响用户体验和系统响应速度。以下是一些使用Oracle SQL Profile的理由：

1. 提升查询效率：通过优化SQL语句，减少查询时间，提升整体系统性能。
2. 降低资源消耗：优化后的SQL语句能够更高效地利用数据库资源，减少CPU、内存和磁盘I/O的消耗。
3. 减少维护成本：通过自动化分析和优化，降低人工干预的需求，减少维护成本。
4. 支持复杂查询：在数字孪生和数字可视化场景中，复杂的SQL查询往往涉及多表连接和大量数据，SQL Profile能够帮助优化这些复杂查询。

如何使用Oracle SQL Profile？

1. 创建SQL Profile

在Oracle数据库中，可以使用DBMS_SQLTUNE包来创建和管理SQL Profile。以下是创建SQL Profile的基本步骤：

-- 捕获SQL语句的执行信息DECLARE  l_sql_id VARCHAR2(100);  l_profile VARCHAR2(100);BEGIN  l_sql_id := DBMS_SQLTUNE.CREATE_SQL_TUNING_TASK(    sql_id => 'SQL_ID',    task_name => 'TUNING_TASK_NAME',    description => 'DESCRIPTION',    plan_hash_value => NULL,    execution_limit => 1000000,    time_limit => 60,    timeout_interval => 60,    parallel => FALSE,    bind_data => DBMS_SQLTUNE.BIND_DATA_AUTO,    bind_count => 100,    row_count => 100,    cardinality => 100,    optimizer_mode => 'DEFAULT',    optimizer_goal => 'ALL_ROWS',    optimizer_env => NULL,    optimizer_features => NULL,    optimizer_index => NULL,    optimizer_statistics => NULL,    optimizer_cost => NULL,    optimizer_time => NULL,    optimizer_memory => NULL,    optimizer_degree => NULL,    optimizer_parallel => NULL,    optimizer_partition => NULL,    optimizer_subquery => NULL,    optimizer_window => NULL,    optimizer_result_cache => NULL,    optimizer_in_memory => NULL,    optimizer_direct_path => NULL,    optimizer_vectorized => NULL,    optimizer_label => NULL,    optimizer_feedback => NULL,    optimizer_statistics_level => 'TYPICAL',    optimizer_trace => NULL,    optimizer_bind => NULL,    optimizer_plan => NULL,    optimizer_plan_hash => NULL,    optimizer_plan_comment => NULL,    optimizer_plan_other => NULL,    optimizer_plan_cost => NULL,    optimizer_plan_cardinality => NULL,    optimizer_plan_rows => NULL,    optimizer_plan_time => NULL,    optimizer_plan_mem => NULL,    optimizer_plan_degree => NULL,    optimizer_plan_parallel => NULL,    optimizer_plan_partition => NULL,    optimizer_plan_subquery => NULL,    optimizer_plan_window => NULL,    optimizer_plan_result_cache => NULL,    optimizer_plan_in_memory => NULL,    optimizer_plan_direct_path => NULL,    optimizer_plan_vectorized => NULL,    optimizer_plan_label => NULL,    optimizer_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem => NULL,    optimizer_plan_plan_degree => NULL,    optimizer_plan_plan_parallel => NULL,    optimizer_plan_plan_partition => NULL,    optimizer_plan_plan_subquery => NULL,    optimizer_plan_plan_window => NULL,    optimizer_plan_plan_result_cache => NULL,    optimizer_plan_plan_in_memory => NULL,    optimizer_plan_plan_direct_path => NULL,    optimizer_plan_plan_vectorized => NULL,    optimizer_plan_plan_label => NULL,    optimizer_plan_plan_feedback => NULL,    optimizer_plan_statistics_level => NULL,    optimizer_plan_trace => NULL,    optimizer_plan_bind => NULL,    optimizer_plan_plan => NULL,    optimizer_plan_plan_hash => NULL,    optimizer_plan_plan_comment => NULL,    optimizer_plan_plan_other => NULL,    optimizer_plan_plan_cost => NULL,    optimizer_plan_plan_cardinality => NULL,    optimizer_plan_plan_rows => NULL,    optimizer_plan_plan_time => NULL,    optimizer_plan_plan_mem