首页>
外国专利>
Optimization of SQL queries using universal quantifiers, set intersection, and max/min aggregation in the presence of nullable columns
Optimization of SQL queries using universal quantifiers, set intersection, and max/min aggregation in the presence of nullable columns
展开▼
机译:在存在可空列的情况下,使用通用量词,集合交集和最大/最小聚合来优化SQL查询
展开▼
页面导航
摘要
著录项
相似文献
摘要
A method and apparatus for optimizing SQL queries by propagating and exploiting column nullability. Column nullability is identified and propagated using a three-valued logic, wherein a column of a table can be identified nullability information is exploited to optimize query operations through transformations. In one aspect of the present invention, quantified predicates (such as " ALL") are transformed into simple predicates involving singleton subqueries so that indexing can be exploited. In another aspect of the present invention, "is not null" predicates are generated and pushed for certain aggregate queries. In still another aspect of the present invention, intersect operations are transformed into joins. The end result is that the present invention can significantly enhance the performance of the queries.
展开▼