Method and data processing system for detecting patterns in SQL to allow optimized use of multi-column indexes

摘要

A database management optimizer detects patterns in SQL that occur when search conditions are present that represent ranges of values across multiple columns of a table. These patterns are recognized and translated into simpler key value ranges that can be used to provide more efficient use of database indexes.