Pushing data-induced predicates through joins in big-data clusters
Proceedings of the VLDB Endowment, pp. 252-265, 2019.
Using data statistics, we convert predicates on a table into data induced predicates (diPs) that apply on the joining tables. Doing so substantially speeds up multi-relation queries because the benefits of predicate pushdown can now apply beyond just the tables that have predicates. We use diPs to skip data exclusively during query optimi...More
Full Text (Upload PDF)
PPT (Upload PPT)