在数据库系统中，索引是提高查询性能的关键工具。然而，索引并非总是有效，尤其是在复杂的查询场景下，索引可能会失效，导致查询性能下降。对于使用Oracle数据库的企业来说，理解索引失效的原因以及如何优化索引策略至关重要。本文将深入分析Oracle索引失效的机制，并提供实用的优化策略和技巧。

一、什么是Oracle索引失效？

在Oracle数据库中，索引是一种用于加速数据查询的结构。通过索引，数据库可以快速定位到需要的数据行，从而减少查询时间。然而，在某些情况下，索引可能会失效，导致查询性能下降，甚至退化为全表扫描。

索引失效是指数据库在执行查询时，未能有效利用索引，导致查询性能降低的现象。这种情况下，数据库会放弃使用索引，转而执行全表扫描或其他低效的查询方式。

二、Oracle索引失效的原因

1. 索引选择性低

索引选择性是指索引能够区分数据的能力。如果索引的选择性较低，意味着大量的数据行具有相同的索引值，这会导致索引无法有效缩小查询范围。

• 原因分析：当索引列的值分布过于集中时，索引的选择性降低。例如，性别字段（男、女）通常只有两个值，选择性极低。
• 优化建议：选择具有较高选择性的列作为索引。可以通过分析表的数据分布，选择列值分散的字段。

2. 索引列未被使用

如果查询中的条件不涉及索引列，或者条件表达式与索引列不匹配，Oracle将无法使用索引。

• 原因分析：例如，索引列是last_name，但查询条件是last_name = 'Smith'，而实际执行的查询条件是last_name || ', ' || first_name = 'Smith, John'，这种情况下索引无法被使用。
• 优化建议：确保查询条件与索引列匹配。可以通过调整查询条件或使用函数索引（如CONCAT）来解决。

3. 数据分布不均匀

如果数据分布不均匀，索引可能无法有效缩小查询范围。例如，在分区表中，某些分区的数据量远大于其他分区，导致索引失效。

• 原因分析：数据分布不均匀会导致索引的分支因子增大，从而降低索引的效率。
• 优化建议：使用分区表或调整分区策略，确保数据分布均匀。

4. 索引覆盖不足

索引覆盖是指查询的所有列都可以通过索引列直接获取，而不需要回表查询。如果索引无法覆盖查询所需的列，Oracle将无法使用索引。

• 原因分析：例如，索引列是order_id，但查询需要order_id和order_date，而order_date不在索引中。
• 优化建议：使用复合索引，确保索引列覆盖查询所需的列。

5. 索引维护不当

索引需要定期维护，否则可能导致索引碎片化或统计信息不准确，从而影响索引的使用效率。

• 原因分析：索引碎片化会导致查询性能下降，而统计信息不准确则可能导致优化器选择错误的执行计划。
• 优化建议：定期执行索引重组和分析，确保索引的高效性。

6. 查询条件过于复杂

复杂的查询条件可能导致索引失效。例如，使用OR条件、NOT条件或多个条件组合时，索引可能无法被有效使用。

• 原因分析：复杂的条件可能导致索引树的分支无法被充分利用，从而降低索引效率。
• 优化建议：简化查询条件，避免使用复杂的逻辑组合。如果必须使用复杂条件，可以考虑使用位运算或优化查询结构。

7. 索引列数据类型不匹配

如果查询条件中的数据类型与索引列的数据类型不匹配，Oracle将无法使用索引。

• 原因分析：例如，索引列是VARCHAR2，而查询条件使用了NUMBER类型。
• 优化建议：确保查询条件中的数据类型与索引列匹配。可以通过显式转换或调整数据类型来解决。

8. 索引列包含大量空值

如果索引列包含大量空值，索引的选择性将显著降低，导致索引失效。

• 原因分析：空值无法被索引有效利用，导致索引无法缩小查询范围。
• 优化建议：避免在空值较多的列上创建索引。如果必须创建索引，可以考虑使用NULL值处理函数（如IS NULL）。

三、Oracle索引优化策略

1. 选择合适的索引类型

根据查询需求选择合适的索引类型。常见的索引类型包括：

• B树索引（B-Tree Index）：适用于范围查询和等值查询。
• 位图索引（Bitmap Index）：适用于选择性低的列，通常用于联接操作。
• 哈希索引（Hash Index）：适用于等值查询，但不支持范围查询。

2. 避免过多索引

过多的索引会增加写操作的开销，并可能导致索引选择性降低。通常，每个表的索引数量应控制在合理范围内。

• 优化建议：定期审查索引，删除不再使用的索引。

3. 使用索引分析工具

Oracle提供了多种工具来分析索引的使用情况，例如：

• EXPLAIN PLAN：用于分析查询执行计划，判断索引是否被使用。
• DBMS_MONITOR：用于监控索引的使用情况。

4. 优化查询条件

通过优化查询条件，可以提高索引的使用效率。例如：

• 避免使用SELECT *：只选择需要的列，减少数据传输量。
• 使用WHERE条件：确保查询条件与索引列匹配。

5. 分区表设计

对于大数据量的表，使用分区表可以提高查询性能。通过分区，可以将数据分散到不同的索引树中，减少查询范围。

• 优化建议：根据查询需求选择合适的分区策略，例如按范围分区或哈希分区。

6. 定期维护索引

定期维护索引可以确保索引的高效性。常见的维护操作包括：

• 索引重组（Rebuild Index）：修复索引碎片，提高查询性能。
• 索引分析（Analyze Index）：更新索引的统计信息，帮助优化器选择最优执行计划。

四、Oracle索引优化的实践技巧

1. 使用EXPLAIN PLAN分析索引使用情况

通过EXPLAIN PLAN工具，可以查看查询执行计划，判断索引是否被使用。例如：

EXPLAIN PLAN FORSELECT * FROM employees WHERE department_id = 10;

执行上述命令后，可以通过DBMS_XPLAN.DISPLAY查看执行计划：

SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);

如果执行计划中显示“INDEX UNIQUE SCAN”，说明索引被有效使用；如果显示“TABLE SCAN”，说明索引失效。

2. 使用DBMS_MONITOR监控索引使用情况

通过DBMS_MONITOR工具，可以监控索引的使用情况。例如：

BEGIN  DBMS_MONITOR.START_SESSION_MONITORING(    session_id => NULL,    serial_num => NULL,    monitor_level => DBMS_MONITOR.SPARSE,    statement_level => DBMS_MONITOR.STMT_TEXT,    plan_level => DBMS_MONITOR.PLAN_TEXT,    bind_level => DBMS_MONITOR.BIND_TYPED,    qep_hints_level => DBMS_MONITOR.QEP_HINTS,    qep_plan_level => DBMS_MONITOR.QEP_PLAN,    qep_stats_level => DBMS_MONITOR.QEP_STATS,    qep_time_level => DBMS_MONITOR.QEP_TIME,    qep_rsrc_level => DBMS_MONITOR.QEP_RSRC,    qep_advisor_level => DBMS_MONITOR.QEP_ADVISOR,    qep_io_level => DBMS_MONITOR.QEP_IO,    qep_buffer_level => DBMS_MONITOR.QEP_BUFFER,    qep_network_level => DBMS_MONITOR.QEP_NETWORK,    qep_other_level => DBMS_MONITOR.QEP_OTHER,    qep_all_level => DBMS_MONITOR.QEP_ALL,    qep_plan_hash_level => DBMS_MONITOR.QEP_PLAN_HASH,    qep_plan_hash_value => NULL,    qep_plan_hash_diff => NULL,    qep_plan_hash_limit => NULL,    qep_plan_hash_step => NULL,    qep_plan_hash_count => NULL,    qep_plan_hash_size => NULL,    qep_plan_hash_num => NULL,    qep_plan_hash_den => NULL,    qep_plan_hash_avg => NULL,    qep_plan_hash_max => NULL,    qep_plan_hash_min => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Selectivity => NULL,    qep_plan_hash Correlation => NULL,    qep_plan_hash Covariance => NULL,    qep_plan_hash StdDev => NULL,    qep_plan_hash Median => NULL,    qep_plan_hash Percentile => NULL,    qep_plan_hash Histogram => NULL,    qep_plan_hash Density => NULL,    qep_plan_hash Select