Sample_rule_for_heuristic_array_query_optimization.png


Summary

Description
English: The algebraic equivalence shown in the downward arrow can lead to a significant performance improvement in an Array DBMS as the right-hand variant requires one (costly) tile stream less than the left-hand variant. Hence, transforming the upper version of the query into the lower one is an optimization that can improve response time.
Date
Source Own work
Author Pebau.grandauer

Licensing

I, the copyright holder of this work, hereby publish it under the following license:
w:en:Creative Commons
attribution share alike
You are free:
  • to share – to copy, distribute and transmit the work
  • to remix – to adapt the work
Under the following conditions:
  • attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
  • share alike – If you remix, transform, or build upon the material, you must distribute your contributions under the same or compatible license as the original.

Captions

Transformation of a query to a more efficient, but equivalent version during array query optimization

Items portrayed in this file

depicts

10 July 2012